PC Review


Reply
Thread Tools Rate Thread

Change from userform view to excel workbook view

 
 
=?Utf-8?B?U0VXYXJyZW4=?=
Guest
Posts: n/a
 
      5th Sep 2007
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 With Quote
 
 
 
 
=?Utf-8?B?Sk5X?=
Guest
Posts: n/a
 
      6th Sep 2007
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:13 AM.