Designating a file with a macro as SAFE

[NextYearSox]

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.

 

[Michael M]

Basically, No.
Your security setting is global and doesn't differentiate between different files.

 

[mikerickson]

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]

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]

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]

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]

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

 

[Rasm]

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]

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]

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 !