Is there a way in which to modify the Macro security using VBA in order to
not get prompted with the Enable Macro prompt?

I am trying to automate a process that opens a Excel spreadsheet and runs a
macro. I want to be able to bypass the Enable Macro prompt.

Any help would be appreciated.

Thanks.