|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 13th, 2007, 03:53 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
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 -- nobbyknownowt 
|
|
#2
February 14th, 2007, 08:18 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
