custom toolbar button questions
thanks, i'm just putting a macro button on each sheet. then they can click
on it when they want it.
--
Gary
"Tom Ogilvy" wrote in message
...
"Custom 1" was an example name of a custom floating commandbar.
Controls(3) referred to the 3rd control/button on that commandbar.
--
Regards,
Tom Ogilvy
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
tried your idea, changed custom 1 to custom button (that's what it says
the
name is anyway), would not work. no name works other than button, but
that
works no matter what my custom button's name is.
i guess i just need a way to assign that code to the custom button on the
toolbar when the workbook opens.
--
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
|