Change from userform view to excel workbook view

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
way to view excel workbook only by password protection	S.REYNA	Microsoft Excel Worksheet Functions	1	28th May 2009 03:57 PM
View mult workbook tabs in excel	=?Utf-8?B?enNkZw==?=	Microsoft Excel Misc	0	19th Nov 2007 09:23 PM
Change Options under Tools>Optioons>View Tab When User Opens Workbook	Minitman	Microsoft Excel Programming	6	30th Sep 2005 05:39 AM
Access quits when change from form design view to normal view	=?Utf-8?B?bWlrZXByaW50Y28=?=	Microsoft Access Forms	2	15th Jul 2005 01:35 PM
View second sheet of Excel workbook in OL2000	Monica	Microsoft Outlook Discussion	1	2nd Sep 2003 06:50 PM