| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change from userform view to excel workbook view
I have a workbook with multiple userforms. I use one of the userforms as a
switchboard/control. When the workbook is opened, you can only see the userforms. This is done intentionally, however i do have a user that needs to have access to the workbook in the design view. I have placed a "Go to Spreadsheet" command button on one of the userforms. Could someone help me with the code to close all userforms and go to the spreadsheets view? thanks -- Stephon Warren |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change from userform view to excel workbook view
How are the userforms opened?
What in the code is making the excel workbook hidden? -- JNW "SEWarren" wrote: I have a workbook with multiple userforms. I use one of the userforms as a switchboard/control. When the workbook is opened, you can only see the userforms. This is done intentionally, however i do have a user that needs to have access to the workbook in the design view. I have placed a "Go to Spreadsheet" command button on one of the userforms. Could someone help me with the code to close all userforms and go to the spreadsheets view? thanks -- Stephon Warren |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| view excel in full screen view | Excel Worksheet Functions | |||
| HOW FIX EXCEL WHERE PRINT VIEW IS DIFFERENT FROM SCREEN VIEW | Excel Discussion (Misc queries) | |||
| I need to change view in excel to left to right | Excel Discussion (Misc queries) | |||
| My view has changed, I want same view as when opening excel | Excel Worksheet Functions | |||
| Change Options under ToolsOptioonsView Tab When User Opens Workbook | Excel Programming | |||
Linear Mode
