View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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