If you want to run macros from the buttons on your form then do the
following:

On the userform, click (the button you want to run a macro from) once
and in the properties box (in the bottom left of the screen) you will
see the name of that button. Lets say its called OpenFinanceSheet..

So then double-click that button to open the code page and paste this
in

Private Sub OpenFinanceSheet_click()

Put your macro code in here

End Sub

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=516225