Macro / password protected worksheet

  • Thread starter Thread starter Schalk
  • Start date Start date
S

Schalk

I have written and password protected a worksheet that is
used by several people to enter data into. I am trying to
record a macro that will make changes to the sheet. The
sequence of events should be 1. Copy sheet containing
macro into sheet 2. Run macro 3. Macro unprotects
password protected sheet 4. Macro makes changes 5.
Macro password protects sheet again.

I have tried to do this, but excel asks for the password!
I do not want to give out the password, which is the whole
point of using a macro!

Can anyone please help?
 
In the Macro, change
Sheets("Sheet1").Unprotect
to
Sheets("Sheet1").Unprotect ("YourPassword")
 
Back
Top