cancel
Showing results for 
Search instead for 
Did you mean: 

How to make report with hierarchy static?

0 Kudos

Hi,

I thought that it will be simple task but I have already spent some time googling and experimenting and still no luck...

I need some of my reports be static - i.e. user can not use expand / collapse options on report.

I have set Lock option FormattingSheet and protected sheet - buttons greyed out.

Still I could expand by double click -> I have switched off "Enable double-click" in User options (although this does not suit me well because I need to block just some reports).

Now I see I still can expand from context menu...

Is there a simple way to freeze expand\collapse just for given report??

Thanks!

ak

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Unfortunately there is no simple way to do it! You can try to remove/hide expand/collapse context options using VBA... but it's not a simple job.

And it's one of the most required features:

"To create a static input form that can't be changed by user"

Vadim