ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto Open Password (https://www.excelbanter.com/excel-programming/374821-auto-open-password.html)

Gordon[_2_]

Auto Open Password
 
Hi...

I'm looking to build password access into the opening of my workbook. If the
password is wrong then the book closes without opening. Any code flying
about? I did a search of this forum but to no sucess.

Thanks in advance.

Gordon...

Paul B

Auto Open Password
 
Gordon, that is built into excel, and all office products, do a save as and
under tools, general options, put in a password to open

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Gordon" wrote in message
...
Hi...

I'm looking to build password access into the opening of my workbook. If

the
password is wrong then the book closes without opening. Any code flying
about? I did a search of this forum but to no sucess.

Thanks in advance.

Gordon...





All times are GMT +1. The time now is 07:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com