Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable save
is there any way to disable the save facility on a
program so that even if someone changes the layout of a shared program or deletes a sheet, there's no way that it is permanent as it won't save tia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable save
Hi
This is not bullet proof but it works for me. Place in workbook module. 'Code to cancel save on workbook 'Private Sub Workbook_BeforeClose(Cancel As Boolean) 'appplication.EnableEvents = False 'Me.Save 'appplication.EnableEvents = False 'End Sub 'Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'Cancel = True 'End Sub HTH Edgar -----Original Message----- is there any way to disable the save facility on a program so that even if someone changes the layout of a shared program or deletes a sheet, there's no way that it is permanent as it won't save tia . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable save
There's no foolproof way. The best thing to do would be to save the file as
read-only with a password, so that it can only be saved under a different filename. -- Vasant "jon" wrote in message ... is there any way to disable the save facility on a program so that even if someone changes the layout of a shared program or deletes a sheet, there's no way that it is permanent as it won't save tia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Do you want to save changes | Excel Discussion (Misc queries) | |||
Disable Save/Save As - not working? | Excel Discussion (Misc queries) | |||
Disable Quick Save & Save As | Excel Discussion (Misc queries) | |||
Disable save | Setting up and Configuration of Excel | |||
Can I disable Save? | Excel Programming |