Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protect for view only
What is the best way to make an Excel Workbook view only status that no
changes can be made to it without authorization? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protect for view only
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 "Kathy" wrote in message ... What is the best way to make an Excel Workbook view only status that no changes can be made to it without authorization? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protect for view only
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. In article , Kathy wrote: What is the best way to make an Excel Workbook view only status that no changes can be made to it without authorization? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I password protect a hidden column in Excel? | Excel Worksheet Functions | |||
Using VB to password protect, but sheet remains visible | Excel Discussion (Misc queries) | |||
Password Protect | Excel Worksheet Functions | |||
Auto Protect workbook with password upon opening | Excel Worksheet Functions | |||
Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions |