Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
password protection Posted by pebblestx on September 05, 2001 12:34 PM
I have Excel 2000, and I need to password protect a workbook. The instructions in the Help tell me to go under the Tools menu and select General Options. There is no selection, and under the General tab under Options, there is no Password to Open box.
I've tried using the Protect Workbook option under Tools, but this only prevents changes. I want to limit who can open and view the file through a password.
Re: password protection Posted by Barrie Davidson on September 05, 2001 12:41 PM
Try SaveAs and click on the Options button (this is Excel97 but I think it would be the same for 2000). This will give you the option to password-protect the file.
Re: password protection Posted by pebblestx on September 05, 2001 12:51 PM
Thanks Barrie! The original instructions were very clear, but you're a life saver!
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.