Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ?

  • Thread starter Markus Obermayer
  • Start date
M

Markus Obermayer

It occurs very often that I open an Excel sheet and do not change anything in that sheet.
Then (after viewing some content) I want close it again. But a message dialog pops up asking me if
I want to save the changes.

I guess that this is the result of embedded macros.

However this is not intuitive and not user friendly.

How do I avoid these kind of popups when no changes took place ?

Markus
 
J

jeff.j.griffith

In my Workbook_BeforeClose method, I have added a line "Saved = True".
That suppresses the message, which can be good in your case, but bad in
the case where a user is expecting that message.
 

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

Suppress "Do you want to save changes you made to ..." message. 8
Excel 2007, Automatically open new worksheet on open. 4
Cannot close Excel - getting "Do you want to save the changes in solver.xla" 3
How do I turn off the "do you want to save" alert in excel? 1
Do you want to save changes to ..... 3
Excel 2003 + script to open and automatically close an excel workb 1
Keeps asking to save. 2
Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file 4

Top