Enable code in a password protected worksheet
Wrap your code with:-
Sheet1.Protect ("password")
'Your code here
Sheet1.Unprotect ("password")
or
Sheets("Sheet1").Protect("password")
Adjust the sheet name and password to suit
Regards,
Alan.
"Barattolo_67" wrote in message
...
I have a spreadsheet that contains some VBA code linkled to some combo
boxes.
I have digitally certified the file, so that I can run the code without
getting a warning once I open it. All works fine: I can open the file,
and
use the combo boxes and the code beyound them.
Now, the problem is that I need to password protect this file. Once I put
a
password to it, the code and the combo boxes do not work any more. When I
open the file, I am asked to enter the password, I put in the correct one,
the file opens correctly, but the combo boxes (and the code beyond them)
do
not work.
Any ideas?
Thanks
|