Keeps asking to save.
 

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

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

Keeps asking to save.
 

Just because a file contains macros isn't enough to make excel think the
workbook has been changed.

If you have an auto_open or Workbook_Open procedure, then that procedure could
be doing something that makes excel think the file changed.

But a more common situation is when the user includes a function that
recalculates automatically--like

AREAS()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()


Sean Timmons wrote:

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


--

Dave Peterson

Keeps asking to save.
 

Dave:

Thanks for this response. The same question has been asked in this group in
lots of different but similar ways. This is just one of those major though
small irritations that come up when something that should be so simple and
obvious isn't and it's very easy to get angry when your product does
something and the reason is not at all obvious.

Jeff Lynch

"Dave Peterson" wrote:

Just because a file contains macros isn't enough to make excel think the
workbook has been changed.

If you have an auto_open or Workbook_Open procedure, then that procedure could
be doing something that makes excel think the file changed.

But a more common situation is when the user includes a function that
recalculates automatically--like

AREAS()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()


Sean Timmons wrote:

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


--

Dave Peterson