Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2008
    Posts
    99
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Enabling Macros for a specific sheet (2007)

    I have a few macros that I have developed, and more that I have copied from this forum. I thank you all for all the help.

    Now that I have 2007, the trust center is defaulted to "notify about macros", and I then have to click on the options and say "run them".

    I understand fully why this is the default (and I am surprised that our IT folks didn't tie down this setting, considering all of the other securities that they have added). And really, I don't want to change it as a standard setting.

    But--is there a way to change the setting just for a specific worksheet? It gets rather old having to enable macros every time the same sheet is opened.
    [I have been here for years; I had to get things restarted]

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    No, you can't change the setting, but you can put the workbook into a Trusted Location.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. The Following User Says Thank You to rory For This Useful Post:

    JohnD1 (2011-02-11)

  4. #3
    Star Lounger
    Join Date
    Feb 2008
    Posts
    99
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by rory View Post
    No, you can't change the setting, but you can put the workbook into a Trusted Location.
    Thanks!! What an "interesting" way of doing things, but whatever works.

    Just as a curiosity, do you know if is this a new feature of 2007, or has it been around a while? If the former, finally I found something new in Excel (besides the challenge of finding all my old commands).

    Lykke til
    [I have been here for years; I had to get things restarted]

  5. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    The Trusted Locations first appeared in 2003 with the new Very High macro setting.
    There are many new weirdnesses in 2007 to brighten our lives...
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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