Excel not prompting to save Add-ins

R

R Avery

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?
 
T

Tom Ogilvy

Sounds like you have taken the optimal path. Generally, addins are intended
to be static.
 
Top