Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 211
Default 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...
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 709
Default 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...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
document in xls and cannot open without a password. How to open? liha Excel Discussion (Misc queries) 2 February 11th 10 07:02 PM
I forgot my password to open an excel document, how do I open it? chris ohearn Excel Discussion (Misc queries) 1 August 11th 08 02:32 PM
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them LJ[_4_] Excel Programming 0 April 27th 06 03:18 AM
Password to open Param Excel Discussion (Misc queries) 1 March 11th 06 07:28 PM
open up an excel program with an auto open macro [email protected] Excel Programming 2 July 17th 05 04:48 PM


All times are GMT +1. The time now is 01:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"