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

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

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

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