Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up a standard form showing incentive calculations | Excel Discussion (Misc queries) | |||
background color showing only when in email form | Excel Discussion (Misc queries) | |||
Add & Delete Records in Excel using a form showing a scrollbar also! | Excel Programming | |||
Run time Error -2147352571 when showing a form | Excel Programming | |||
How to set focus back to sheet after showing a user form | Excel Programming |