Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Atlanta, GA
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unwanted Macro disable (office xp)

    I am trying to download a file attached to an email. When I try to open the file, the macros are disabled because my security is "too high". When I look at Internet options, I see a medium security. There is no mention in this panel about macros, only talks about Active X and Java.

    How can I enable the macros.

    Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unwanted Macro disable (office xp)

    I'm assuming the file is an Excel file. It isn't IE that is the problem, it is Excel. Check the Macro Security of Excel.

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Unwanted Macro disable (office xp)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> wfjdi0r1

    OK the macro security and the IE settings are two separate things.

    Lets deal with the MS-Excel security.

    1) You are using Excel 2002, and that is good, so you need to go into your <font color=red>Tools menu </font color=red> and choose <font color=red>Macro </font color=red> and then <font color=red>Security </font color=red>

    2) If you set it to Medium, then you will have the option of disabling macros per workbook, vs all the time, or none of the time. Its my favorite setting since I write a lot of macros.

    IE on the other hand, has its own security and there are plenty of articles about what is the best practise with it. I'll dig one out and post it for you in a reply.

    Hope this helps

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Unwanted Macro disable (office xp)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Again wfjdi0r1

    OK I also wanted to add this to my earlier reply:

    When you say: I am trying to download a file attached to an email.... and then you say When I try to open the file

    OK so I understand that you have managed to detach the attached file from the e-mail message and now you are working with MS-Excel 2002 as opposed to working within Internet Explorer and displaying a MS-Excel workbook.

    If you are working within Internet Explorer and displaying a MS-Excel workbook, I am not sure if you could have the macros running in this situation. So its best to detach and work in MS-Excel.

    Just thought of that as I was reading my post.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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