Userform focus question

viper

Active Member
Joined
Feb 15, 2002
Messages
382
Is there a way that I can have my userform display before the file is opened?

I have a userform that will show the user the information they will be wanting to see. I would like for when the file is opened just the userform displays with the information, I have a button for the user to click if they want to add or view the information and another button that will close the file if the userforms data was all they needed to see.

My boss keeps telling me to just keep the files simple but I like all the extras.

Simple never impressed anyone.

Thanks,
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Simply "NO", but you could set the size of the UserForm to fill the whole screen.

Do you already have it set up as:

Private Sub Workbook_Open()
UserForm1.Show

James


_________________
This message was edited by James on 2002-05-05 16:17
This message was edited by James on 2002-05-05 16:19
 
Upvote 0
how about having worksheets hidden on closeing.
Then have the form run on opening the workbook.
Then if the user selects the command button to see the worksheets you just unhide them ?
 
Upvote 0
Not really.

You'd need a WorkBook_BeforeOpen event, which doesn't exist.

One suggestion I'd have is to maybe mess around with a full screen userform, or a userform that fills the whole of the spreadsheet area. So long as you make it modal, there's not much the user can do about it.
 
Upvote 0
On 2002-05-05 16:14, Nimrod wrote:
how about having worksheets hidden on closeing.
Then have the form run on opening the workbook.
Then if the user selects the command button to see the worksheets you just unhide them ?

Dammit! You guys are too fast. :biggrin:

One comment on Nimrod's post though. There has to be at least one worksheet visible at all times, so hiding all of the sheets isn't an option.
 
Upvote 0
It seems that you have to have at least one sheet visiable. But maybe you could minimize the workbook on opening and then Max it only if required. This may give you the "effect" your looking for.
 
Upvote 0
Thanks for all the suggestions. I'll try them and see which one works best.

Thanks again,
 
Upvote 0
Nimrod - Wouldn't a minimized Workbook hide the UserForm also? I'd also like to be able to have a UserForm be the first thing the user sees when opening the Workbook, but I'm not following what you mean by minimizing the Workbook to accomplish this.
 
Upvote 0
Hey Viper,

I have an Excel file with a Splash page. There is one visible sheet but it is filled black, and no data what so ever. OnOpen the Splash runs; when the timer is up and it comes time to Unload ( in a module) I put the sheets.visible code in like this:

_____________________________________

Private Sub KillTheForm()
Unload Splash1
Sheets("Sheet1").Visible = True
Sheets("Sheet2").Visible = True
Sheets("Sheet3").Visible = True
End Sub
______________________________________

This works just fine for me. When the Splash unloads the sheets are now visible.

Regards,

ViperGTS
This message was edited by ViperGTS on 2002-09-25 19:33
 
Upvote 0
Thanks gts,

It's been so long since I posted this that I can't remember which workbook I used this on.

RogerC,

to minimize your open workbook put this code into the workbook_open sub

Activewindow.windowstate = xlMinimized
Userform1.show

Upon opening of your workbook it will minimize the workbook and then display your userform. You will then need to add
activewindow.windowstate = xlMaximized at the end of a timer or in the click_event of a command button to show your workbook.

HTH

Thanks again G,
viper

_________________
I appreciate the help from everyone at Mr. Excel.

viper
This message was edited by viper on 2002-09-25 20:52
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top