Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to have a userform displayed and be able to work in a different spreadsheet
Dear experts,
I would like to run a macro contained in Worksheet B from Worksheet A. I need to keep the macro in worksheet B, so I can't just copy the modules in worksheet A, and as this is part of a series of steps and macros etc. I have used a userform with a button linked to worksheet B. My problem is the following: the userform stays visible after clicking the worksheet B button and does not allow me to work in worksheet B. I can't just hide the userform or unload it as I need it for the following steps of my process! If it's useful the very simple code I have used is: in the module: Sub Show_Userform() UserForm1.Show 0 End Sub in the userform: Private Sub CommandButton1_Click() Workbooks.Open ("WorksheetB.xls") End Sub Do you maybe know how to solve this problem? Many thanks in advance! Best regards, Valeria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet columns are displayed numerically instead of alpha | Excel Worksheet Functions | |||
Format problem in displayed userform | Excel Worksheet Functions | |||
How to make userform work publically with hidden sheets? | Excel Discussion (Misc queries) | |||
How to make userform work publically with hidden sheets? | Excel Worksheet Functions | |||
Label Caption Just Wont Work on UserForm | Excel Programming |