Skip to Content
0
Former Member
Apr 11, 2010 at 09:08 AM

Dynamic change in Indentation& Expansion when the Work Sheet is protected

27 Views

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