How do I include my password in a macro?

[Barry Katcher]

I have a workbook that is used by several end-user with sheets that are password protected so they can't overwrite formulas. I have a button which runs a macro that I recorded that unprotects the sheet, performs several other operations, and then protects the sheet again.

The problem is, that when the macro is run by the end-user, it stops and a drop-down box asks for the password to be entered to unprotect. Obviously, it would be defeating the purpose to give the users the password.

My question is: is there any code I can insert in the macro to automatically enter my password in the box to unprotect, and once again, enter it twice to re-protect?

Thanx in advanx.

 

[B_2]

Sheets(sheet1).Unprotect Password:="B_2"

Sheets(sheet1).Protect Password:="B_2"

 

[Barry Katcher]

Thanks, B_2. The migraine I've had the past 6 months has suddenly cleared up.