how to stop it asking if i want to enable macros

RET79

Well-known Member
Joined
Mar 19, 2002
Messages
526
how do i stop excel asking me if i want to enable macros? thanks.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Under the Tools->Options menu there should be a way to set macro security levels.

I am using XP and there is a tab you select "Security" and then click on the "Macro Security" button on the bottom of that tab.

I'm sorry I don't remember exactly where this topic is located in previous versions of Excel, but it is in the Options menu.
 
Upvote 0
Try Tools | Macro | Security and set it to low. If you get emails, be sure you know what you're opening. Also, disable the preview in Outlook, otherwise, a spreadsheet could be opened automatically if the email is html, it has an object reference to excel and it's the top item that's selected.
 
Upvote 0
You can also create yourself a Digital Certificate by running the self-cert program that comes with Office:

Run the Office 2000 setup program again.

On the Select Features screen in the setup program, expand Office Tools.

Select Digital Signature for VBA projects, click the arrow next to your selection, and then select Run from My Computer.

In Windows Explorer, locate and then double-click the file SelfCert.exe in C:Program FilesMicrosoft OfficeOffice.
Note Because a digital certificate that you create yourself isn’t issued by a formal certification authority, macro projects that are signed by using such a certificate are referred to as self-signed projects. Depending on how your organization uses the digital-signature features in Microsoft Office, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons. Learn about digital signatures.

For more information about creating digital certificates, see Help in Visual Basic for Applications.

This should allow you to keep your security settings at medium, and as long as you tell the computer on which you are using the spreadsheet that you are a trusted source, it will only ask you the first time you use the file if you wish to enable macros. Everytime after that it should just load automatically.

HTH,
Corticus
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

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