General discussion
October 19, 2006 at 09:23 AM
gruple

Macro to input password for read only workbooks

by gruple . Updated 19 years, 12 months ago

I have several workbooks that I need to open and recalculate often. All of these workbooks are read only is you don’t have the password. I want write a macro to open all of these workbooks and to automatically enter the password as they open instead of me typing it in 50 times. I have tried searching the database, but I can’t find anything that has worked. I know how to make the macro to open the workbooks, I just don’t know the syntax to enter the password. Any help will be very very appreciated.

This discussion is locked

All Comments