Hi Freinds
In my Rolling forecast Input Schedule, i have the make the indentaion on rows using the EVPRO function and calling HELEVEL for the member ID which are in my ROW KEY RANGE.
But when i am changing the CV to a different Material Group having child as Materials, the Indentation is not working automatically, meaning the column where i use the EVPRO Function to call the HLEVEL property is not expanded automatically.
Secondly when i am Using the Set Work Book Option to Lock the work Sheet & Use EXPAND ON CURRENT VIEW CHANGE" option and subsequently when i am changing the CV to a different material group its not expanding, giving a message that " The Work Sheet is Protected, Check the Password...."
Any idea how to resolve the issues.
Thnaks & Regards
Krish