Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: "Enable Macros" pop-up box on open of workbook

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a workbook with a variety of macros. I would like to atuomatically "enable macros" on opening of the workbook from any one of the users (potentially 30 or more users so I don't want them to "disable" the macros). Is there a way that I can remove the pop-up box that comes up to "enable macros" or "disable macros" on opening the workbook?

    Thank you!

    Anita

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In one word, No.

    One option would be to get a Digital Signature and sign your project with it, that way, even if the user has macro security set to High, your project will load.

    If they have it set to Medium, they'll have the option to enable/disable macros.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Guest

    Default

    Juan,

    Thank you for your answer. I didn't think there would be an easy way to handle it.

    Anita

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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