View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Code doesn't disappear

Excel must be loaded in your system memory. If you hit Ctrl+Alt+Delete and
click 'Task Manager', do you any instances of Excel under the 'Processes' tab?

Maybe just before you exit the A.xls book you need to include something like
this:
http://www.tek-tips.com/viewthread.c...=923847&page=1

In the ThisWorkbook Object put a small snippet of code like this:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call 'YourCloseMacroNameHere...see example in link above
End Sub


HTH,
Ryan---