ActiveWorkbook.Unprotect not working

[Beall49]

I'm sorry, I'm sure you have gone over this a million times, I searched and couldn't find a specific answer to this problem.

Basically, I have a master sheet, which goes out and opens many sheets (I will just use the first sheet as the example) and grabs data and returns it to the master. These sheets are password protected due to each analyst has there own sheet and we dont want others taking a peek.

I am using ActiveWorkbook.unprotect Password:="password" so the code can automatically put the password into the sheet and grab the info, unfortunately the password prompt comes up every time and interupts. Everywhere I have read, says this is the correct command, any ideas what Im missing?

Please Login or Register  to view this content.

Any help would be appreciated. Thanks in advance.

[Leith Ross]

Hello Beall49,

This syntax is correct if the workbook is already open. When opening the workbook for the first time, you need to include the password named argument in the Open statement...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Beall49]

Wow..


...You're good, that was awesome, it works perfect, thank you for your time.