Unlocking sheets with VB password

[tasander]

Hi

I have a macro that opens up a number of spreadsheet and then does some work on them, however all of these spreadsheets have passwords on which i have to type in manually every time each spreadsheet is opened.

Is there a way that i can hard code the password in to the code or get the user just to type it in once and then it is remembered for all the other files opened in the same routine.

Many thanks

 

[VoG]

You can hard code it like this

ActiveSheet.Unprotect password:="abc"
'
'your code
'
ActiveSheet.Protect password:="abc"

 

[tasander]

perfecting i had my code wrong so it wasn't accepting my version of that line

Thanks