G
Guest
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.
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.