Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2003
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro Secruity Message (2000/2003/XP)

    When opening a workbook with macros I am getting a message "The macros in this project are disabled...." - Normally when macro secruity is set to Medium the I get a message to Enable or Disable macros however I am not getting this message? Is there are setting that overides this normal dialog?

  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro Secruity Message (2000/2003/XP)

    Has your security setting been changed from Medium? check it

  3. #3
    Lounger
    Join Date
    Mar 2003
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro Secruity Message (2000/2003/XP)

    Yes - even when the security is set to low I get this message? It is defintiely machine specific as the workbook works (with macros enabled) fine on another machine

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro Secruity Message (2000/2003/XP)

    I see this message occasionally too. All my workbooks have digital certificates attached so I don't know if it's related to that or not. In my case, I delete the certificate, saved the workbook, re-selected the cert and saved the workbook again. No more error message. I forgot what I was doing but I know I was going back/forth between three versions of Excel (97, 2000, 2002).

    Actually, it's a bogus error message (at least it's always been in my case) <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> because macros still ran. I'd get the error when I tried to add a new named range. I'd add the name (from the name box, top left of toolbar) & press Enter. This is when the message showed. I'd press OK to clear it and the named range that I wanted to add was accepted just fine. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    If you don't have a digital cert on this workbook, then I don't know what the error is. <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15>

    Deb

Posting Permissions

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