Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disable save
Hi y'all
I have a sheet I have written where the user completes the data and prints it out using a macro. Once the sheet is printed the changes are no longer required (in fact they become a risk). I have macro which can be activated to clear the data. I have the code to disable the save on close option but is there a way I can stop the sheet being saved by the other available methods or should I run the clear macro on close? cheers Nobby |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Disable save
I would run the Clear macro as part of the print macro, iow, print, then clear
-- Hth Kassie Kasselman "nobbyknownowt" wrote: Hi y'all I have a sheet I have written where the user completes the data and prints it out using a macro. Once the sheet is printed the changes are no longer required (in fact they become a risk). I have macro which can be activated to clear the data. I have the code to disable the save on close option but is there a way I can stop the sheet being saved by the other available methods or should I run the clear macro on close? cheers Nobby -- nobbyknownowt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save-As Option Disable | Excel Worksheet Functions | |||
IS THERE A SETTING TO DISABLE SAVE ON EXITING? | Excel Discussion (Misc queries) | |||
Disable save function | Excel Discussion (Misc queries) | |||
Disable save Function | Excel Discussion (Misc queries) | |||
Disable "Save As" Option | Excel Discussion (Misc queries) |