Unprotecting and Reprotecting Workbook To allow macro to run

Hi

The attached file i need code inserted into vba to unprotect workbook allow the exisiting macro's to run, and re-protect on opening. To do the same in reverse on closure of workbook. I have tried various ways and fail each time.

The macro alters the workbook structure so need it to unprotect to allow changes- re-protect so no one can change workbook structure whilst working on it on closing would need the workbook unprotected again allow the changes to happen again and re-protect.

The attachment was supplied by RoyUK. See link http://www.excelforum.com/excel-prog...e-options.html

Thank you in advance

In each macro add

Activeworkbook.Unprotect
'code
Activeworkbook.Protect

or

Worksheets("Sheet 1").Unprotect Password:="Whatever"
'code
Worksheets("Sheet 1").Protect Password:="Whatever"

etc

I tend not to use the Password option during development, it is bit of a pest when running code over and over again.
Obviously you will have to use .Protect/.Unprotect during development to check that it works for you.

You can also use

Please Login or Register  to view this content.

i.e. an empty string
This will ask you for a password, don't enter anything in the inputbox, just click Okay/Enter.

If you put anything in the inputbox, remember what it was, Excel certainly will!

Finally, when you are ready, introduce your password, remember all the usual Password rules - case sensitive, illegal characters etc....
You can use find/replace -

Password:=""
with
Password:="Your Password"

to fill throughout your code.

Don't try mixing passwords in a project until you know what you are doing.

I'm sure you will get the idea pretty quickly!

P.S.

It can be a good idea to password protect your VBa project when finished.
This will prevent users opening your code and therefore finding the workbook/sheet passwords.

Cheers