Sheet Protection and XLA code
I am trying to unprotect a spreadsheet from some code in a workbook. Below
is the code:
ActiveWorkbook.Sheets("TRANSACTIONS")
. Unprotect strPassWord
€˜*** do stuff to worksheet
End with
This code is in a xla workbook.
If the code is called from the activeworkbook in a non save mode then it
works.
If the code is called from the Workbook.BeforeSave event then the code stops
with a protection error.
At this point, even in a debug mode, the sheet protection will not turn off.
Is there a known issue that prevents the activeworkbook sheet protection to
not be change during the before save event?
Any thoughts or work around?
Thanks in advance
--
Stewart Rogers
DataSort Software, L.C.
|