System variable for "changes made"

[Lon Sarnoff]

My application provides the user a Save button which creates a well-defined
file name. I have disabled the user's access to the File>Save 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

[Tom Ogilvy]

thisworkbooks.Saved = True

--
Regards,
Tom Ogilvy


"Lon Sarnoff" <[email protected]> wrote in message
news:[email protected]...
> My application provides the user a Save button which creates a
well-defined
> file name. I have disabled the user's access to the File>Save 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

[Nigel]

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" <[email protected]> wrote in message
news:[email protected]...
> My application provides the user a Save button which creates a
well-defined
> file name. I have disabled the user's access to the File>Save 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

[Lon Sarnoff]

Thank you. Simplicity is golden.
--
Lon Sarnoff


"Tom Ogilvy" wrote:

> thisworkbooks.Saved = True
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Lon Sarnoff" <[email protected]> wrote in message
> news:[email protected]...
> > My application provides the user a Save button which creates a
> well-defined
> > file name. I have disabled the user's access to the File>Save 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
>
>
>