Designating a file with a macro as SAFE

NextYearSox

Active Member
Joined
Oct 24, 2003
Messages
287
My current security settings require the user to manually authorize the open of a file with a Macro. Is there any mechanism for telling Excel that certain files are safe so I don't have get asked the question every time? Otherwise, I still want to maintain the global safety setting.
 
Hi Mike
Slightly different.
If a security is set to low the workbook will open without prompting the user.
Medium will ask the user if they wish to enable macros
High won't open any workbook with a macro
Thanks for letting me know.
 
Upvote 0

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
The macro security setting is a setting in Excel, right?

Couldn't it be manipulated through another application?

So that you could access the files you want to access through another application, which would temporarily reduce the security settings, then reset them when the instance of that other application closed.

If this was the case then macro security would be empty of meaning ... it isn't desirable to be able to adjust a user's macro security settings at will...
My current security settings require the user to manually authorize the open of a file with a Macro. Is there any mechanism for telling Excel that certain files are safe so I don't have get asked the question every time? Otherwise, I still want to maintain the global safety setting.
In Office 2007/2010 you may set folders as "trusted". So files in certain locations will always run macros.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,216,741
Messages
6,132,448
Members
449,728
Latest member
teodora bocarski

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