P
Paul Martin
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
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