Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2005
    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 default it returns the settings to medium. very confusing!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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