View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ?

This is probably caused =by having volatile worksheet functions, such as
=TODAY().

You could get around it, but it could stop it being saved when it should, so
I would just live with it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Markus Obermayer" wrote in message
...
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