Thread: Showing form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Kredlo Tim Kredlo is offline
external usenet poster
 
Posts: 11
Default Showing form

I have workbook(FillOrders) with code that opens another file (Orders) and
fills various worksheets (in Orders) from several other files that are opened
and then closed. When 'FillOrders' has completed filling all the worksheets
in 'Orders' , the following code is executed:

Workbooks("Orders.xls").Worksheets("Headers").Acti vate
Workbooks("FillOrders.xls").Close

The code in 'Orders' for the worksheet 'Headers' activate event is
"frmMenu.Show".
After 'FillOrders' is closed (by code above) , the worksheet 'Headers' (in
'Orders') is displayed, but frmMenu is not being displayed. If I switch to
another sheet and back to 'Headers', the form is displayed as expected.

How can I get this form to show automatically after 'FillOrders' is closed?

TIA