Cannot run the macro in Excel

Question

Hello everybody,

Although I enabled content and the file is located in a trusted location I keep getting the message 'Cannot run the macro <macro name>. The macro may not be available in this workbook or all macros may be disabled' 

I would like to enable all macros, but just for a specific file.

I am running Excel version 2003 (build 12624.20466)

Thank you in advance.

Answer 1

Hi

Macros can live in many different places.

The default location is to save a macro within a workbook. When this is done, the macro is always available to anyone using the workbook.

In your case, one of the other options was chosen.

The other options are storing a macro in the macro author's Personal Macro workbook or in a different workbook. When the save to Personal Macro workbook option is chosen, the macro is available only to the user who made the macro. When a is located in a different workbook from the current workbook, both workbooks are required be available to use the macro. If done in a way that the two workbooks have relative references, when both workbooks are together the macro will work.

Answer 2

Hi MassimoSartoris,

I'm an Independent Advisor and consumer of Microsoft products just like you. Let me help you with your concern.

Try to follow the steps to enable or disable macros in Office files on the below link

https://support.office.com/en-us/article/enable...

Answer 3

I have tried that several times, but I keep getting the message "Because of your security settings, macros have been disabled"

Answer 4

Follow the below link to enable or disable macros in Office for Mac

https://support.microsoft.com/en-us/office/enab...

Answer 5

I recreated the spreadsheet and now it works. It was probably a question of locations.

Thank you for your help.