Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
System variable for "changes made"
My application provides the user a Save button which creates a well-defined
file name. I have disabled the user's access to the FileSave menu item. I would like to clear whatever system variable is used to flag "changes made" to the document which in turn prompts the "Do you want to save?" inquiry to the user upon closing. Is there such a variable which I can access, and if so, what is the setting which would suppress the inquiry? -- Lon Sarnoff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
System variable for "changes made"
thisworkbooks.Saved = True
-- Regards, Tom Ogilvy "Lon Sarnoff" wrote in message ... My application provides the user a Save button which creates a well-defined file name. I have disabled the user's access to the FileSave menu item. I would like to clear whatever system variable is used to flag "changes made" to the document which in turn prompts the "Do you want to save?" inquiry to the user upon closing. Is there such a variable which I can access, and if so, what is the setting which would suppress the inquiry? -- Lon Sarnoff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
System variable for "changes made"
ActiveWorkbook.Saved = True
Will set the workbook 'system variable' to a saved status, closing the workbook after invoking the above will close it without any messaging. -- Cheers Nigel "Lon Sarnoff" wrote in message ... My application provides the user a Save button which creates a well-defined file name. I have disabled the user's access to the FileSave menu item. I would like to clear whatever system variable is used to flag "changes made" to the document which in turn prompts the "Do you want to save?" inquiry to the user upon closing. Is there such a variable which I can access, and if so, what is the setting which would suppress the inquiry? -- Lon Sarnoff |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
System variable for "changes made"
Thank you. Simplicity is golden.
-- Lon Sarnoff "Tom Ogilvy" wrote: thisworkbooks.Saved = True -- Regards, Tom Ogilvy "Lon Sarnoff" wrote in message ... My application provides the user a Save button which creates a well-defined file name. I have disabled the user's access to the FileSave menu item. I would like to clear whatever system variable is used to flag "changes made" to the document which in turn prompts the "Do you want to save?" inquiry to the user upon closing. Is there such a variable which I can access, and if so, what is the setting which would suppress the inquiry? -- Lon Sarnoff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
Can locating "FIND" results be made easier on the eyes? [Office 20 | Excel Discussion (Misc queries) | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
What are the System Tables named "Print Area" & "Print Titles"? | Excel Programming |