Run script to automatically enable macros to bypass Security Prompt

[heytherejem]

Hello!

So this relates to a company computer, so I can't change security settings - but I have this macro I use a fair amount to perform a short-cut task. However, every time I run it, I have to select 'Enable Macros' from the Windows Security Alert prompt.

Infuriating.

Any work-around to this? Some top-secret code I can add to my macro to somehow enable itself before it's even run??

Here's hoping.....

Jemma

[underscoreBadger]

I am also on a company network, and going in manually through Excel Advanced Options - Trust Centre Settings shows the macro settings greyed out.

However,

Please Login or Register  to view this content.

still works in VBA (call the macro after this line) - just need to remember to switch it back to

Please Login or Register  to view this content.

afterwards.

Not sure if this solves it for your corporate network but worth a try if you haven't already.