insert password using vb

  • Thread starter Thread starter abbeville
  • Start date Start date
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
 
ActiveSheet.Unprotect ("password")

Other Macro

ActiveSheet.Protect ("password")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

corrupted formula in protected worksheet 21
Password protection in macro ( Anybody can view my password in VB 2
Allow user to insert rows on protected worksheet 1
Password Protection 6
modify macro to include more tabs 1
Run Macros in a Password-protected workbook? 1
Password and Macro 4
Disable spreadsheet when copied to incorrect file path or differen ip address 4

Back
Top