Use the Workbook_Open event procedure. In the ThisWorkbook code
module, paste the following code:

Private Sub Workbook_Open()
userform1.Show
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sam1" wrote
in message
...

Hi,

is it possible for a user form to open automatically when the
.xls doc
containing it is opened?


--
sam1
------------------------------------------------------------------------
sam1's Profile:
http://www.excelforum.com/member.php...o&userid=18280
View this thread:
http://www.excelforum.com/showthread...hreadid=521537