Stop the "Enable Macros" Prompt

yoko

Active Member
Joined
Sep 5, 2006
Messages
349
Hi,

Is there away to stop the "enable macros" prompt that pops up when ever you open an excel spreadsheet with a macro on it.

I know it’s a security feature to stop people spreading viruses etc using macros but its really annoying on some spreadsheets I use.

Cheers
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

rjp

Board Regular
Joined
Jan 5, 2006
Messages
148
You can use digital certificates to prevent it but every user will need to have the certificate installed. It's been a while since I looked at it but if I remember correctly there's plenty of good info on MSDN or via Google.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
You could always amend your security settings eg to Low (in which case the macros will be automatically enabled) or to Very High in which case they will be automatically disabled.

I wouldn't recommend either of these though. The setting also applies to all workbooks, not just particular ones.
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Goo afternoon yoko

Just a follow up from rjp's comments : you may well find commercial digital certificates prohibitively expensive. If this is the case you could use the windows selfcert.exe program useful. If you use a selfcert it will throw up a different warning stating who is the author of the file - still looks a lot better than the standard Excel macro warning box,,,

HTH

DominicB
 

rjp

Board Regular
Joined
Jan 5, 2006
Messages
148

ADVERTISEMENT

Thanks DominicB, as I said it's been a while since I used it but using the SelfCert method is what I was trying to recommend. It can allow macros to be enabled without *any* warning. At least it does on the workbook I've used it on.
 

yoko

Active Member
Joined
Sep 5, 2006
Messages
349
Hi,

Ah ok thought I wouldnt have much choice!

Cheers folks
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Hi rjp

It can allow macros to be enabled without *any* warning. At least it does on the workbook I've used it on.
If I remember rightly, using selfcert will open a workbook containing macros without warning only if the certificate has been generated on the same machine. If you open it on a different machine you do get a message, but it looks more professional than the standard "enable/disable/cancel" jobbie.

HTH

DominicB
 

Forum statistics

Threads
1,136,421
Messages
5,675,759
Members
419,585
Latest member
popsin

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