Forum Discussion

AlexanderH740's avatar
AlexanderH740
Copper Contributor
Aug 10, 2024
Solved

Macros are not executed via inserted button

Can someone help me with the following problem:

I want to execute a macro via a button. I have created the macro via a recording and it can also be started from the macro overview. If I now assign macros to a button via "Right-click > Assign macro ..." and then click on the button, the macro is not executed. What could I have forgotten here?

Thank you for any help!

4 Replies

  • AlexanderH740 

    If you now right-click the button and select Assign Macro... from the context menu, is the macro already listed in the Macro name box?

    • AlexanderH740's avatar
      AlexanderH740
      Copper Contributor
      Yes. The macro is listed and I can sellect it, but after that the button just does nothing after selecting it and pressing OK.
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        AlexanderH740 

        Does the problem persist after quitting Excel (saving the workbook if necessary), then reopen the workbook?

Resources