Problems with Auto_Close when opening spreadsheet from a macro

  • Thread starter Thread starter L2B
  • Start date Start date
L

L2B

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
 
L

How about using the RunAutoMacros method to run it

Application.RunAutoMacros xlAutoClose
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Back
Top