Thread: Problems with Auto_Close when opening spreadsheet from a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L2B[_2_] L2B[_2_] is offline
external usenet poster
  
Posts: 1
Default Problems with Auto_Close when opening spreadsheet from a macro

I have an auto_close macro in a spreadsheet. When I open the spreadsheet
directly it executes perfectly on closing it. However, when the
spreadsheet is opened from another macro this code does not execute.

Is there an option I can set to ensure it runs, or do automacros never
execute from another workbook?

Many thanks.

L


--
L2B
------------------------------------------------------------------------
L2B's Profile: http://www.excelforum.com/member.php...o&userid=23140
View this thread: http://www.excelforum.com/showthread...hreadid=482235

Reply With QuoteReply With Quote