Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Scheduled task, enable macro?! (2000)

    I have a scheduled task, that opens an Excel spreadsheet with an auto macro. The process is fuly automaated, however when the spreadsheet opens, it asks whether macro's can be enabled. Can this be bypassed?

    I should add, when i put the secutiry setting as low, and save as.....by default it returns the settings to medium. very confusing!

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

    Re: Scheduled task, enable macro?! (2000)

    The best way is to sign the VBA project in the workbook with a digital certificate. When you have done so, you'll be asked once whether you trust the certificate, when you click Yes, you won't be prompted again.

    See Description of digital certificates

Posting Permissions

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