Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have what I thought was a simple requirement. I have a workbook that has 2
simple choices to retrieve one workbook or another. When I click on the button the program is retrieved just fine., The userform works just fine and the save and close work just fine. The only issue is that when it "returns" to the original program, the menu that was there now disappears and has to be reloaded. Does anyone know of a way to return to the original program and still see the userform? Here is the code that opens the 2nd workbook. Private Sub GetTour_Btn_Click() Workbooks.Open ("Tour Quoting Program (Pricer).xls") Call DisplaySplash 'This line does not appear to be executing End Sub Sub DisplaySplash() Call HideApp Call RemoveCustomMenu Call AddCustomMenu On Error Resume Next Splash.Show On Error GoTo 0 End Su Any help would be appreciated. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing a program which was opened with shellexecute | Excel Programming | |||
Closing a program | Excel Programming | |||
Closing Excel Program correctly? | Excel Programming | |||
[HELP] closing a program with VBA code | Excel Programming | |||
Need program to ask me to save changes when closing | Excel Programming |