Hi all,
If I protect a sheet with password and after I press the UNDO button, the
sheet is unprotect without any password
maybe you think that this isn't a real problem, because If you save and reopen
the file, you will not allowed to unprotect the table without insert the
password.
Unfortunately there are also macro writers.... :-)
a very common task is the following:
Sub PrepareSheet()
MySheet.Unprotect("password")
'do something in the sheet
'
MySheet.Protect("password")
End Sub
Is there any workaround to avoid that user may unprotect the sheet by pressing
undo?
thank you
Paolo M
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
