ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Password Prompt With Read Only Option (https://www.excelbanter.com/excel-discussion-misc-queries/104932-password-prompt-read-only-option.html)

Paperback Writer

Password Prompt With Read Only Option
 
Is there a way to password protect an Excel document, but allow for READ ONLY
access if the user doesn't know the password?

Alan

Password Prompt With Read Only Option
 
Just save the file as 'Read Only'
Go File Save As Tools (on the right of the dialogue box) General
Options Choose 'Password To Modify' Follow the prompts for the password
and that's it done,
Regards,
Alan.
"Paperback Writer" wrote in
message ...
Is there a way to password protect an Excel document, but allow for READ
ONLY
access if the user doesn't know the password?




Dave Peterson

Password Prompt With Read Only Option
 
File|SaveAs|Tools|General Options
Give it a (memorable!) password to modify.

(Don't use the password to open.)

Paperback Writer wrote:

Is there a way to password protect an Excel document, but allow for READ ONLY
access if the user doesn't know the password?


--

Dave Peterson


All times are GMT +1. The time now is 08:02 AM.

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