Password protect for view only

K

Kathy

What is the best way to make an Excel Workbook view only status that no
changes can be made to it without authorization?
 
O

Otto Moehrbach

Kathy
You can protect all the sheets and have an InputBox pop up when the
file is opened. The InputBox text would say something about the file is
read-only unless the user has a key word (password) and to enter that if he
has it. If he enters the right word, the sheets would be unprotected. If
not, not.
But be aware that Excel is not designed as a secure platform. Anything
like passwords or restrictive code can be broken/bypassed by anyone with
more than rudimentary Excel knowledge. HTH Otto
 
J

JE McGimpsey

Save it as a PDF file.

There is no XL protection that can't be easily bypassed by anyone with
enough savvy to find these newsgroups.
 
Top