Change from userform view to excel workbook view

[SEWarren]

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

 

[JNW]

How are the userforms opened?
What in the code is making the excel workbook hidden?