Code to Unprotect a Workbook

[aresquare1]

I recorded the following code to Unprotect an entire Workbook yet VBA tells me that the code has an error "Compile error: Expected: end of statement". Also, once we get the error corrected, how do I change this line of code since the workbook is password protected?

Please Login or Register  to view this content.

Thanks for your help,
RR

[OllieB]

There is only one parameter for the Unprotect method

Please Login or Register  to view this content.

[AlphaFrog]

Change the password to suit.

Please Login or Register  to view this content.