Place a User Form on Start Up

Hello again,

Firstly, thanks for the guys who helped on my last problem. Now, here's my next!

I have a user form (UserForm1) that I need to have automatically open when the spreadsheet is opened (it controls unhiding various worksheets). Can anyone suggest what I need to do for this to happen?

TIA,

SamuelT

Hi Samuel,

Try:

'=============>>
Private Sub Workbook_Open()
UserForm1.Show
End Sub
'<<=============

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module:

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)

Select 'View Code' from the menu and paste the code.

Alt-F11 to return to Excel.


---
Regards,
Norman



"SamuelT" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again,
>
> Firstly, thanks for the guys who helped on my last problem. Now, here's
> my next!
>
> I have a user form (UserForm1) that I need to have automatically open
> when the spreadsheet is opened (it controls unhiding various
> worksheets). Can anyone suggest what I need to do for this to happen?
>
> TIA,
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
> http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=552614
>

In the OPEN event of the workbook put

userform1.show

that should do it!


SamuelT wrote:
> Hello again,
>
> Firstly, thanks for the guys who helped on my last problem. Now, here's
> my next!
>
> I have a user form (UserForm1) that I need to have automatically open
> when the spreadsheet is opened (it controls unhiding various
> worksheets). Can anyone suggest what I need to do for this to happen?
>
> TIA,
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=552614