Hi Ceemo,

Move the button code into the userform's initialze event, i.e.:

Private Sub UserForm_Initialize()

'Your button code

End Sub


---
Regards,
Norman



"ceemo" wrote in
message ...

I have a form that when opens has a button attached, tht when pressed
executes a sub that makes changes on the frm.

I would like to get rid of the button and have the sub auto execute
when the form opens. ive tries linking the sub to form initilize but no
joy

any ideas


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=482433