View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default 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