Userform focus question

[viper]

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,

[James]

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 ]

[Nimrod]

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 ?

[Mark O'Brien]

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.

[Mark O'Brien]

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.

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.

[Nimrod]

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.

[viper]

Thanks for all the suggestions. I'll try them and see which one works best.

Thanks again,

[RogerC]

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.

[Scottie P™]

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 ]

[viper]

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 ]