Protecting Workbook w/ password using VBA

Hi Everyone,

I reuqire my macro to unhide some sheets to pull the data from before hiding the sheets so that no body has unrestricted access to that data...

I have been doing it like this:

Please Login or Register  to view this content.

and it works great, however, I now want to protect the work book, and I can't work out how to get the password into the VBA script for both unhiding and hiding purposes.

Any ideas???


Regards,

Steve

Use the code

Please Login or Register  to view this content.

where the "..." is the name of the workbook and "X" is the password used to protect it.

hope this helps