HELP - How do I know if a spreadsheet has been modified

L

LP

Hi all,

I am developing a C# application that uses an Excel object on a form. I
want to promt the user if he/she want to save the changes only if the
spreadsheet has been modified. Is there a FLAG somewhere in excel that
would tell me if it has been modified?

There must be because excel itself uses this when changes are made to a
sheet.

How can I identify that it has changed?

Thanks for all suggestions and replies!!!
 
I

immanuel

Check the value of ActiveWorkbook.Saved. It's boolean: TRUE when saved and
no changes have been made; FALSE when the file is dirty.

/i.
 
L

LP

Works like a charm...thanks a million

LP


immanuel said:
Check the value of ActiveWorkbook.Saved. It's boolean: TRUE when saved and
no changes have been made; FALSE when the file is dirty.

/i.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Need Help with Macro Security 1
Identify whether the Word document has modified 0
VBA - exporting serial letters to single documents 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Changing color 9
How do I clear a form? 0
ODBC Data Source - Excel 2010 0

Top