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