Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |