Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have developed .xla addins.
After installing the addin, run Excel.exe and add a new workbook and add a change to the workbook, and click 'x' icon on the top right of the Excel window. Then I'm asked whether I save the change or cancel the closing operation. I clicked 'Cancel', then , all the workbooks are not closed , however , ..xla addins are gone. How can I avoid this? To test the phenomenan, I inserted the code below into 'Module1's of those addins. sub auto_open() MsgBox ThisWorkBook.FullName & " is opened." end sub sub auto_close() MsgBox ThisWorkBook.FullName & " is closed." end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink operation cancelled.... | Excel Discussion (Misc queries) | |||
Unloading / closing a form with the escape key | Excel Programming | |||
Email Sent or Cancelled | Excel Programming | |||
How to avoid re-initialisation when Unloading form | Excel Programming | |||
Unloading an Add-In | Excel Programming |