Hello -

I have a relatively complex workbook (by my company's standards
anyway), containing a number of Protected Sheets. These sheets are
manually protected (by me) before publishing, but I've also included a
Workbook_Open macro (in ThisWorkbook) in case I forget to protect the
sheets. Within this macro, I've specified UserInterfaceOnly:=True and
also EnableOutlining=True .... this was necessary as one of the sheets
contains a great number of groups.

For most users, everything works great ... cells are protected,
outlining works, etc. HOWEVER, a few users report that they aren't
able to expand the outlining. When I ask them to send me their copy
so I can see what's going on, I'm not able to replicate the issue --
outlining works fine!

What could the problem be? Other macros seem to be working for these
same users, so 'security level' doesn't appear to be an issue ....
This is driving me nuts!

Thanks,
Ray

Are the users who are experiencing problems using earlier version(s)
of Excel? Protection was expanded sometime after Excel 97 (I'm not
sure with exactly which version).

Mark Lincoln

On Dec 20, 7:08 am, Ray wrote:
Hello -

I have a relatively complex workbook (by my company's standards
anyway), containing a number of Protected Sheets. These sheets are
manually protected (by me) before publishing, but I've also included a
Workbook_Open macro (in ThisWorkbook) in case I forget to protect the
sheets. Within this macro, I've specified UserInterfaceOnly:=True and
also EnableOutlining=True .... this was necessary as one of the sheets
contains a great number of groups.

For most users, everything works great ... cells are protected,
outlining works, etc. HOWEVER, a few users report that they aren't
able to expand the outlining. When I ask them to send me their copy
so I can see what's going on, I'm not able to replicate the issue --
outlining works fine!

What could the problem be? Other macros seem to be working for these
same users, so 'security level' doesn't appear to be an issue ....
This is driving me nuts!

Thanks,
Ray