ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel not prompting to save Add-ins (https://www.excelbanter.com/excel-programming/289612-excel-not-prompting-save-add-ins.html)

R Avery

Excel not prompting to save Add-ins
 
In Excel10, I have encountered a problem whereby when i quit Excel, it will
prompt me to save my Personal.xls (if there are unsaved changes), but it
will NOT do the same for my custom add-ins. It will blissfully quit, quite
content to erase all my unsaved work.

I have worked around it by making a Workbook_BeforeClose() event that checks
the saved status and prompts the user to save... but why does it do this in
the first place? Is it a bug in Excel?



Tom Ogilvy

Excel not prompting to save Add-ins
 
Sounds like you have taken the optimal path. Generally, addins are intended
to be static.

--
Regards,
Tom Ogilvy

"R Avery" wrote in message
...
In Excel10, I have encountered a problem whereby when i quit Excel, it

will
prompt me to save my Personal.xls (if there are unsaved changes), but it
will NOT do the same for my custom add-ins. It will blissfully quit,

quite
content to erase all my unsaved work.

I have worked around it by making a Workbook_BeforeClose() event that

checks
the saved status and prompts the user to save... but why does it do this

in
the first place? Is it a bug in Excel?






All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com