Issues with Macros

Peggy2015

Board Regular
Joined
Oct 19, 2015
Messages
109
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

hvdlinde

New Member
Joined
Nov 30, 2016
Messages
11
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,461
Messages
5,596,276
Members
414,051
Latest member
tabecker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top