View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Clift Jack Clift is offline
external usenet poster
 
Posts: 6
Default Activeworkbook.Saved

I am trying to use the activeworkbook.saved = true method
to inhibit the user being prompted to save a workbook that
has had no material changes to it (i.e. ignore changes
such as updating comboboxes etc. that the user does not
see or care about).

This property seems to be reset however prior to the
workbook being closed, and I cannot find the what is doing
this (presumably it is internal to the application), or
how to work around.

Any ideas?

Regards

Jack