Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have a template that I do not want it to be saved under any circumstances when any part of it is modified. I have been able to program the X button not to save with: Private Sub Workbook_BeforeClose(Cancel As Boolean) Saved = True End Sub but not sure what coding is needed so it will not save if the user click the save button or chooses the file|save or file|save as option from the menu item. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change tooltips for user-modified colors? | Excel Discussion (Misc queries) | |||
Alert user that row has been modified by changing row color | Excel Worksheet Functions | |||
Log User Name and Date when userform was run/modified | Excel Programming | |||
Save user-defined chart types in a shared Excel template? | Charts and Charting in Excel | |||
Saving changes to an modified color template | Excel Discussion (Misc queries) |