Getting around dialog boxes

[Rickatwork]

Hello,

Thanks in advance for anyone that could help me!

I'm writing a script to remove all the 'protection' from excel sheets, the only problem is that the protection is password-ed. So far my script will do 95% of the work, but I still have to key in the password for each sheet. Im hoping that someone would know how to insert the password into the script so I dont have to type it each time.

Thanks again,

-Rick

[Rickatwork]

ActiveSheet.Unprotect ("password") does the trick