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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,281
Office Version
  1. 2013
Platform
  1. Windows
Basically, No.
Your security setting is global and doesn't differentiate between different files.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,790
I'm a Mac user and the security is different there, but my understanding is that no matter how low a Windows user/administrator sets the security, opening a workbook with macros will always create a dialog box asking whether Macros should be enabled.

Is that the case?
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,281
Office Version
  1. 2013
Platform
  1. Windows
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
 

Glory

Well-known Member
Joined
Mar 16, 2011
Messages
640

ADVERTISEMENT

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.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,281
Office Version
  1. 2013
Platform
  1. Windows
Glory
Yeah, you're probably correct. I guess if you google enough you'd find it, but it won't be on this Forum.
I believe it would be a breach of Forum rules to suggest methods to bypass security of any sort
 

Rasm

Well-known Member
Joined
Feb 9, 2011
Messages
500

ADVERTISEMENT

In xl goto options - you will see a whole section on security and trusted sources - I use xl2007 - not sure what you use.
 

Rasm

Well-known Member
Joined
Feb 9, 2011
Messages
500
In xl goto options - you will see a whole section on security and trusted sources - I use xl2007 - not sure what you use.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,337
Office Version
  1. 365
Platform
  1. Windows
Your security setting is global and doesn't differentiate between different files.
As has been alluded to recently in this thread, that is no longer the case - Excel 2007+. You can, among other things, set certain files to be 'Trusted' or set certain locations as 'Trusted'.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,281
Office Version
  1. 2013
Platform
  1. Windows
Hi Peter
I was aware of that point made by Rasm, I wasn't sure of the OP's version.
Which, I might add I should have asked for first !
 

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,467
Members
409,883
Latest member
asharris90
Top