View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?