Getting around Excel Macro notifications in AD

  • Thread starter Thread starter Mike Canmore
  • Start date Start date
M

Mike Canmore

I hope someone has had to deal with this before, regardless, any suggestions
are much appreciated

Overview: AD GPO resets macro security level from low to medium

Problem: for automated macros (excel files with macros) to run on a
schedule, can't require user input (don't want to click on "Enable" to run
it when its automated)

Solutions: Purchase an external application (any suggestions here) that can
mimic user clicking on Enable as soon as Excel opens

Preferred Solution: Program it, via Excel Macro or VB (have to have a
service type app running all the time reading process ID and name, once it
detects Excel, have it click on Enable -- now only if I was a decent coder)

Note: Changing the GPO is not an option

If anyone has code that tracks process name, or that can mimic clicking on
windows or such, much appreciated

Mike
 
Back
Top