Issues with Macros

[Peggy2015]

Hello,

I have an issue with a macro that a colleague has created. When I open up the workbook I get the 'Security Warning Macros have been disabled.' I click on the 'Enable Content' button. I then get the message 'Do you want to make this a trusted file?' prompt, which I click Yes.

I then go to the page that has been set up with icons that have macros attached it gives me the error message 'Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose to enable macros...' I've already said to Enable, so I don't understand why this message comes up. These workbooks and the macros work for my colleague on their PC. I have used another PC and the macros work for me there. I've gone into advanced settings to change my macro level to low and the same error messages come up.

I don't understand why this is happening? Can you please advise?

Best wishes,
Peggy

 

[hvdlinde]

you have to enable macro's in your options from Excel.
go to File menu->options-> trustcenter->settings for trustcenter-> settings for macro-> select bottom option 'al macro enabled'

it is possible that the menu items have a differnt name there i'm using a different laungage.

harm

 

[Peggy2015]

Hi Harm,
I did this too, and the macros still didn't work.