Excel bug with sheet protection, user interface only??
No, it isn't a bug - it is the designed behavior. Settings such as this and
scrollarea, enableautofilter, enableselection and enableoutline are
temporary and are not retain when the workbook is closed.
You need to use the workbook_Open event or other appropriate event to set
them so they are in effect when the workbook is opened.
--
Regards,
Tom Ogilvy
"Dag Johansen" wrote in message
...
Hi,
I want to allow users to protect a sheet not for security
reasons but rather to avoid unintentional overwrites. But
VBA should still be allowed to modify the sheet (used to
refresh some data in a spreadsheet while protecting the
criteria from unintentional modification).
I call WorkSheet.Protect(pwd, UserInterfaceOnly:=True) and
it works like a dream - for the remainder of the session.
I save, close Excel and start a new instance, load the
saved workbook and... now the sheet has "normal"
protection and VBA is NOT allowed to make modifications.
Does anyone know if this is a bug in Excel and/or how to
overcome the problem?
Help greatly appreciated! Regards,
Dag Johansen
|