insert password using vb

A

abbeville

I have multi worksheets in a template with formulas. I can hide th
formulas but if I add a password, my macros stop and ask for th
password when the macro is in a protected worksheet. Is there a way o
adding the password to a macro so that the macro will run smoothl
without stopping and asking for a manual insertion of the password?
Thanks
Do
 
C

Celtic_Avenger

ActiveSheet.Unprotect ("password")

Other Macro

ActiveSheet.Protect ("password")
 
Top