on 09-22-2014 4:42 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.