Home |
Search |
Today's Posts |
#1
|
|||
|
|||
prevent saving a worksheet
When I post my worksheet to my website, I want the user to be able to use the
filtering functions I have in the worksheet but I don't want them to be able to save the worksheet to their hard drive. Is there a way that I can do this? Thanks! -- looking... |
#2
|
|||
|
|||
In the 'ThisWorkbook' code section of the workbook, put...
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True End Sub Of course, if they have macros set to not run, this won't work. HTH, Gary Brown "looking4help" wrote: When I post my worksheet to my website, I want the user to be able to use the filtering functions I have in the worksheet but I don't want them to be able to save the worksheet to their hard drive. Is there a way that I can do this? Thanks! -- looking... |
#3
|
|||
|
|||
If on a website, I don't know of a method to prevent a user from right-click
and Save Target As. Unless your website can restrict that capability? Excel certainly can't prevent it. Gord Dibben Excel MVP On Thu, 17 Mar 2005 08:13:03 -0800, looking4help wrote: When I post my worksheet to my website, I want the user to be able to use the filtering functions I have in the worksheet but I don't want them to be able to save the worksheet to their hard drive. Is there a way that I can do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent unhide of rows/columns w/out worksheet protection? | Excel Discussion (Misc queries) | |||
Saving a Worksheet | Excel Discussion (Misc queries) | |||
When saving a worksheet in excel message "document not saved" | Excel Discussion (Misc queries) | |||
can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions | |||
When saving workbook only the first worksheet gets saved. | Excel Worksheet Functions |