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
|