Shared Workbook: loading Userforms
 

Hi all

I have a shared workbook that has a Userform for accepting input for a
protected worksheet. Protection uses UserInterfaceOnly = True so
that macros can write to the protected sheet.

The workbook works fine on the original machine, but if a second user
attempts to load the Userform (which writes to a worksheet), a message
appears as if the UserInterfaceOnly property had not been set.

The message is: Run-time error 1004. The cell or chart you are trying
to change is protected and therefore read-only....

I also have a custom toolbar button that Protects worksheets setting
UserInterfaceOnly = True, and another that Unprotects worksheets. If
I try to use either of these buttons in Shared mode, I get a 1004
error.

Some other code attempts to create a new worksheet at the start of a
month, but this also fails in Shared Mode.

Everything works fine in Shared Mode if I don't protect the
worksheets, but I want them to be protected. Can anyone offer any
insight or suggestions as to whether these issues can be resolved in
Shared Mode?

Thanks in advance

Paul Martin
Melbourne, Australia