View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Keeps asking to save.

Any time you enable macros, Excel will assume changes. To stop being asked,
take out the macro. Otherwise, not much you can do.

"Frank Rizzo" wrote:

Hello, I've added a small macro to my spreadsheet (e.g. I added a
button, then when the user clicks the button -- some code is kicked off).

So now, I'll open the spreadsheet, Excel will ask me to enable macros
and without making any changes, I'll attempt to close Excel down.
Immediately, Excel pops up a dialog box asking me whether I want to save
changes.

Q1. Why is it asking me to save changes when I haven't made any?
Q2. How can I make it stop?

Regards