Unlock whole workbook by putting the password in a cell in 2010

[Andyf_p]

Hi, I'm not new to Excel but I'm quite new to actually doing anything with it and I'd like to get a handle on some of the better fetaures available.

I'd like to be able to unlock the whole of a workbook by putting the password into a specific cell and then the whole thing locks again when it is saved. I have been able to find the coding to do this for a worksheet but I'd really like to be able to unlock the whole project. Please help

Thanks & regards,
Andy

[nathansav]

Google Excel Workbook Unprotect VBA, this should explain how to do it, its only 1 line of code.

Record yourself doing it, which would be quicker.

[:) Sixthsense :)]

This will protect all sheets of that workbook. Replace Protect to Unprotect to unprotect all sheets of that workbook

Please Login or Register  to view this content.

[Andyf_p]

Ok cool, thanks guys, I've tried:

Please Login or Register  to view this content.

This is somewhere near what I'd like but I'd like the password fixed in the code, so I'm not putting it in everytime I want to protect the sheet, I just simply save and the workbook is locked again. Can it be added as a line in the code? I have tried making UnprotectPW = to "Andy" but that didn't work

Also, if the password is incorrect it returns a runtime error can error handling be used to make it simply tell you that and close the message box?

[nathansav]

Yes, error handling will do what you need, and setting the variable to be Andy should also work.

[Andyf_p]

This is kind of going past my capabilities at the moment, is there any good, preferably cheap learning tools I can get hold of?

[nathansav]

Yes, GOOGLE

Google error trapping vba and unprotecting workbook using vba

[Andyf_p]

Google is fantastic! How d'you think I found this forum?!? I've read, learnt and tried loads of basics already