1

I have a long-running Excel 2019 file that suddenly stopped working correctly. A set of shapes are linked to macros (defined as public Subs) - clicking these has started to generate the following error

Cannot run the macro "abc". The macro may not be available in this workbook or all macros may be disabled.

Now, if I instead link a regular command button to the same macro, it runs fine.

Any ideas why?

Improve this question
2
  • 1
    Maybe this is helpful. Commented Nov 16, 2021 at 15:19
  • 1
    Yep, that fixed it thanks. Commented Nov 16, 2021 at 16:02
Related questions
1
Excel 2013 ribbonx xml: CustomUI works fine but resulting button refuses to run my macro
0
Excel VBA Runs but not when Macro Assigned
0
Excel macro call does not work from timer, but does from another macro
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.