"Enable Macro option button" disabled in Excel 2007

dine

Board Regular
Joined
Feb 16, 2010
Messages
59
Hi there,

I was trying to change the Macro security settings in Excel 2007. The "Enable all macros" option button is disabled in my system, not sure how to get it enabled. The button "Trust access to the VBA project object model" is Enabled and also tried with that one, but I am not able to execute the macro with that.

Any assistance on how to enable the option button is hight appreciated.

Thanks,
Dine
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
1. Go to Excel Options (that's the circle in the top left corner of the screen, then bottom right of the dropdown)
2. Go to "Trust Center" and click on the button called "Trust Center Settings"
3. Select "Disable all Macros with Notification" and click "OK"
(This will remain as the default setting for Excel)
4. Close the your file and then re-open it
(When the file is re-opened, a security notification will appear above the edit line)

5. Click on the notification "options" and choose "Enable this Content" and click "OK"
(Stage 5 will need to be repeated each time a macro enabled file is opened)

The warning is not as "in ya face" as version 2003, you just have to get used to it
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,024
Members
448,543
Latest member
MartinLarkin

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
Back
Top