I am trying to automate a process which opens an excel spreadsheet within ACCESS. I am trying to turn off the macro security popup warning that comes up. I have the security level set to medium to give me a choice to enable or disable but in this particular instance I would prefer to avoid the message all together. Is this possible through code? Additional Info: When I open the file with out the code I get a choice to enable or disable the macro. When I launch it through access I don't get a enable or disable, I get a yes or no popup. Also, the file really does not contain a macro but it does have a few lines of code in the "ON OPEN EVENT".
Thanks for any help someone could offer.