LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problems with opening Excel spreadsheet. jyunii Excel Discussion (Misc queries) 1 November 11th 08 05:23 AM
Starting Auto_Close macro based on an IF statement questor Excel Discussion (Misc queries) 4 February 25th 08 10:22 PM
Run a macro when opening a spreadsheet Duncan Help Excel Discussion (Misc queries) 5 January 10th 05 05:33 PM
Problems opening a text file using macro! aiyer[_50_] Excel Programming 2 August 27th 04 08:36 PM
unable to close macro using auto_close or application.quit gloria Excel Programming 1 January 14th 04 07:50 AM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"