ok, thanks. this is why i needed to change the macro, it was pointing to the
other workbook

'N:\My Documents\Excel\RECCU\FSA\Blank1.xls'!Run_Form

it would load this workbook and then run the form
--


Gary


"Tom Ogilvy" wrote in message
...
Code can't run userforms in other workbooks without taking extraordinary
measures, so it should use the userform in that workbook.

tools=Customize,
This puts Excel in a design mode for commandbars. Leave the dialog
showing,
then go to your button and right click on it. Select Assign macro.
Change
the setting for what macro to run.


In code, you can do something like

Application.Commandbars("Custom 1").Controls(3).OnAction =
"MyWorkbooks.xls!MyMacro"

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i created a user form in my master workbook. created a new macro button
to
run it. i then exported the user form and imported it into the client's
workbook. when i click the macro button, it opens my workbook and runs
the
form.

so, i have 2 questions:

1. how do i edit the custom button to assign which macro it runs? ended
up
deleting it and creating a new one.

2. how do i specify in the code to run show the userform from the current
workbook?

i tired thisworkbook.userform1.show and activeworkbook.userform1.show.



--


Gary