Hi All,
I've been scouring forums, but I have not been able to resolve this question.
I seek to allow normal users to perform limited editting of a worksheet, including creating and expanding/collapsing Outlines i.e. Show detail/hide detail
I have succeeded in this:
However, a consequence of setting UserInterFaceOnly to TRUE is that users can now select macro buttons that run operations on protected cells in the sheet. Only users that have a higher level of access password (i.e. one ot disable the sheet protection) are intended to be able to do this.
Is there a realtively straight forward way I can enable outlining whilst still forbiding macro buttons?
Thanks for your help.
Bookmarks