I
Iain King
We are currently using Excel 2000. My workbook is very code driven, and
has to be protected, so on workbook_open it protects all the sheets with the
UserInterfaceOnly:=true setting. This works fine. However, it does mean
that I can't share the workbook (because you can't protect a shared
worksheet). In Excel 2003, with it's more advanced protection facility,
does it allow you to protect a sheet equivalently to UserInterfaceOnly in
the normal protection dialogue? Basically, can you protect a sheet from the
user but not any VB code you have running in the background?
Thanks, Iain King
has to be protected, so on workbook_open it protects all the sheets with the
UserInterfaceOnly:=true setting. This works fine. However, it does mean
that I can't share the workbook (because you can't protect a shared
worksheet). In Excel 2003, with it's more advanced protection facility,
does it allow you to protect a sheet equivalently to UserInterfaceOnly in
the normal protection dialogue? Basically, can you protect a sheet from the
user but not any VB code you have running in the background?
Thanks, Iain King