Hi WANNABE
Enter the macro name in the click event of the button
Private Sub CommandButton1_Click()
Call yourMacroName
End Sub
Or use a button from the Forms toolbar
you can right click on it and use Assign macro
--
Regards Ron de Bruin
http://www.rondebruin.nl
"WANNABE" <breichenbach AT istate DOT com wrote in message ...
I have a procedure that consists of 4 subs, they are all saved in a module "Update", the first sub calls out to the others in
order. I would like to run this from a button on the spreadsheet. However when I create the button, and select 'view code' it
creates a macro in the spreadsheet. Can this be redirected to run from the module or can I call my Update module from it, and
please tell me how ???