Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro Security (2002 XP)

    My spreadsheet is not allowing me to open sheets with macros because the security level is set high. How can I alter this? Thanks

    Farmer

  2. #2
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro Security (2002 XP)

    Hi

    Open Excel and go to Tools / Macro / Security

    Check the option - medium, and OK out of this.

    CLose Excel and now when you open you're file Excel should prompt you as to whether you want to run macros or not. If you don't want to be asked then you can set the security settings to Low, but this is not advisable as malicous code could mess your system up.
    Thanks,

    pmatz

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro Security (2002 XP)

    Great, thanks for this and also your observations.
    F

Posting Permissions

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