View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chuck buchanan chuck buchanan is offline
external usenet poster
 
Posts: 4
Default Workbook1 opens Workbook2 and runs Workbook2's macro

Workbook1 has code below:

Workbooks.Open Filename:="Workbook2.xls"

Workbook2 has this pertinent code:

Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("00:00:01"), "myFormShow"
End Sub

Sub myFormShow()
myOrder.show
End Sub

Workbook1 does open Workbook2, but the designated form does not appear.

Is there a better (i.e., "correct") way to ensure that the form appears?

Thanks for your consideration.

--
Chuck Buchanan
Special Projects Coordinator