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

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