Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restricting a Spreadsheet so users cannot save changes
I have a spreadsheet I've created that pulls information from one worksheet
to another and then runs several calculations on the data. I want to be able to post this on our intranet and allow users to look up their own information, but do not want them to be able to make or save changes. I have restriced the spreadsheet so they can only change the one cell they need to lookup their information, but is there a way to lock it completely so they will not have the option to use the "SAVE AS" feature to save it on their hard drives? All I want them to be able to do is look up their information and to print.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restricting a Spreadsheet so users cannot save changes
GeneR wrote...
I have a spreadsheet I've created that pulls information from one worksheet to another and then runs several calculations on the data. I want to be able to post this on our intranet and allow users to look up their own information, but do not want them to be able to make or save changes. I have restriced the spreadsheet so they can only change the one cell they need to lookup their information, but is there a way to lock it completely so they will not have the option to use the "SAVE AS" feature to save it on their hard drives? All I want them to be able to do is look up their information and to print.... There's no way to disable Save As without macros, and users can always disable macros before opening your workbook. The best alternative is calling do-nothing UDFs in most formulas in your workbook so that those formulas evaluate to #NAME? errors when macros are disabled. Even so, more sophisticated users could alter the VBA code, even if you try to password protect your VBA modules. Moral: spreadsheets weren't designed to be black boxes. That may change with Excel 2007 if you have all the other server infrastructure (overhead) necessary to take advantage of Excel web services, but it wouldn't exactly be an elegant solution. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save problem for linked excel spreadsheet | Excel Discussion (Misc queries) | |||
How to allow network users to view spreadsheet, but not print it? | Excel Discussion (Misc queries) | |||
Cancel user's changes but save other changes | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
save spreadsheet as web page | Excel Discussion (Misc queries) |