Why am I getting this error message?

[Mel Smith]

I have several macros stored in my Personal Macros workbook. When I try to run one of them, I get the following error message:

"Cannot run the macro 'PERSONAL.XLSB!Delete_Rows'. The macro may not be available in this workbook or all macros may be disabled."

When I go to the VBA window and click on 'run macro', it runs perfectly. I've checked the Trust Centre settings, which allow macros to run and the other macros stored in the Personal workbook work as expected.

Any thoughts, please?

Mel

 

[Mel Smith]

I have several macros stored in my Personal Macros workbook. When I try to run one of them, I get the following error message:

"Cannot run the macro 'PERSONAL.XLSB!Delete_Rows'. The macro may not be available in this workbook or all macros may be disabled."

When I go to the VBA window and click on 'run macro', it runs perfectly. I've checked the Trust Centre settings, which allow macros to run and the other macros stored in the Personal workbook work as expected.

Any thoughts, please?

Mel

To add to the query - if I use Alt+F8 and select the required macro it works!
Mel