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
|