Use Macro To Change Macro Assigned To Command Button

Hi CVinje
depends but something like

Please Login or Register  to view this content.

Please Login or Register  to view this content.

sub are call testthree and testtwo

Scratch this message, the macros weren't tested properly. See message later on.

CVinje;

Originally Posted by CVinje

Not really sure what to do with the provided macros

I'm sorry, I tried simplifying my macros, but I did it here in Excel Forum without testing them. I just assumed they would work like they do in my workbooks. They don't, so here they are after testing.

I'm assuming that you don't know how to modify your menus. If that's wrong, I apologize.

1. Copy all these subs/functions into a Standard Module.

2. Run "Create_MenuButton_For_Button_OnAction()". It will put a temporary button on your Menu Bar with the Caption "Set_Button_OnAction". The button will be removed when you close Excel.

3. Select a button with your right mouse button. This will put a shadow around the button.

4. While the button is selected, click "Set_Button_OnAction" on your menu. This will assign a macro "Button_Clicked()" to the button.

5. Click the button (you'll have to move your cursor to another cell 1st). This will stop inside "Button_Clicked()" where you can tell VBA where you want the button to go.

6. Create a "Case <button caption>" and your real sub() name inside "Button_Clicked()"

7. Go back and click the button again and it should go to the sub you want to assign.

8. Do steps 3 - 7 with another button.

When you create a new button, assign the macro "Button_Clicked()" to it, and put the real sub() inside Button_Clicked(), and you can then change it anytime you want without having to modify the button itself. You can use my "Create_Button()" macro to do that with just one mouse click.

Please Login or Register  to view this content.