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 |
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 |
All times are GMT +1. The time now is 05:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com