markkramer
Board Regular
- Joined
- May 8, 2002
- Messages
- 162
Unlike the posts that I've located on the site, I actually know the password of the workbook I'm trying to open! My question is how to pass that password to the workbook in my code so that the user is not bothered with having to enter in the password (I don't want them to know it anyway).
I tried this combination but that didn't do the trick:
Workbooks.Open Filename:="myworkbook.xls"
ActiveWorkbook.Unprotect Password:="abcd1234"
Somehow I need to open the workbook and pass the password at the same time.
Thanks for you help!
M
I tried this combination but that didn't do the trick:
Workbooks.Open Filename:="myworkbook.xls"
ActiveWorkbook.Unprotect Password:="abcd1234"
Somehow I need to open the workbook and pass the password at the same time.
Thanks for you help!
M