Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Macro Security Popup (Office 200 w/ Windows2000)

    Hi,

    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.
    Kevin

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro Security Popup (Office 200 w/ Windows2000)

    Any VBA code will cause the macro warning, as will the presence of controls from the Control Toolbox or other ActiveX controls.

    There is no way to change the macro security settings in code; this is by design, otherwise it would be all too easy for viruses!

    Perhaps digital signatures are the way to go, but I can't help you with that.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro Security Popup (Office 200 w/ Windows2000)

    If you could turn off that warning in VBA code, then so could any virus. I don't think that is really what you want.

    If you digitally sign the macro code with a digital signature (you can create one with the SelfCert program that comes Office), then the first time any user uses the code he will get a message asking if the digital signature can be trusted. If he responds yes, then there will not be a message from then on.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •