View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Determine if template file is dirty

Using Office 2003 and Windows XP;

I have an unsaved copy of a template file opened in memory; now I want to
control how the user exits. How can I determine if the file is dirty?

Note that I cannot use "If ThisWorkbook.Saved = True" because template
copies are never saved when they are first opened; what I need to know is
whether the user has made any changes;

Is there a neat and tidy command that will do this without having to code
checks against 30 controls looking for a change? Please answer, "Why yes
there is..." and then post example VBA. You help is greatly appreciated.

Thanks for your assistance.