Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Duluth, Minnesota, USA
    Posts
    215
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    All,

    Thanks for all the help on converting my radio buttons to the VBA version and selectively "greying out" the inappropriate secondary choices. The spreadsheet now functions more clearly, but this has come at a price. When a user now opens the spreadsheet, they are asked to enable the enclosed macros (or not). In my search to make the tool easier to use, I was successful in one place, but introduced a previously missing complication.

    Is there a way to prevent the "Enable macro" dialog when the spreadsheet is opened?

    Douglas

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    The user could set macro security to Low, but that is not a good idea, since macro viruses would run without any warning. It is something users will have to live with.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    To prevent the enable macros from activating with safety, you can create certificates and register them to excel. If excel opens a workbook that is certified, it will not prompt the macros diolog.
    To create a certificate, choose START - SEARCH (or find) - FILES OR FOLDERS
    Type SelfCert.EXE
    Double click on the application and follow the prompts to create a certificate.
    Once you have created the certificate, open excel and choose TOOLS - MACRO - SECURITY. Click on trusted sources and select the certificate you made.
    This tells excel that all workbooks marked with this certificate can be trusted and it will not prompt the dialog!
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    From the online help
    <hr>Because a digital certificate you create yourself isn't issued by a formal certification authority, macro projects signed by using such a certificate are referred to as self-signed projects. Certificates you create yourself are considered unauthenticated and will generate a warning in the Security Warning box if the security level is set to High or Medium. Depending on how Microsoft Office digital-signature features are being used in your organization, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons.<hr>
    So using SelfCert.exe may not be the ideal solution.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    Hans, what is refered to in the quote you posted raises some interesting issues now????! <img src=/S/confused.gif border=0 alt=confused width=15 height=20> I have a VBA for excel microsoft press manual, that teaches the user that using selfcert and the trusted sources facility is an effective way to handle the prompt dialog from activating on open. I have used it (not often), but without any problems myself!
    If according to that warning you posted, selfcert is not effective, then what is its role and why bother having it available in the first place. Also, when and how would you use the trusted sources feature in excel? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    SelfCert is mainly meant for personal use - you can use it to avoid the macro warning for your own workbooks. Since the digital signature has not been authenticated by an independent authority, it is not necessarily valid for use by others. In a corporate environment, it depends on how security is set up. Where I work, I cannot add anything to 'Trusted sources'.

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    Hans: It has been a while since I used selfcert, but I believe that if you send the workbook to another user Excel will display a security message the first time the workbook is opened asking if the certificate should be trusted. If the user clicks Yes, then there should be no message in the future.
    Legare Coleman

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    Frankly, I never use certificates myself, so I don't really know. I just copied the warning about the limitations of using SelfCert from the Excel 2002 online help.

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    That is correct, Legare.

    However, if the user modifies the Workbook selfcerted by another user, the user will get a message along the lines of (from memory, and with embellishments) "You are not the owner of the certification attached to the macros in this Workbook. Accordingly the certificate will be discarded. Is this OK, or shall we hunt you down and sue you?"

    I know this because my main template occasionally dishes this message out to my staff.
    -John ... I float in liquid gardens
    UTC -7DS

  10. #10
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win

    >However, if the user modifies the Workbook selfcerted by another user,...the certificate will be discarded.

    For the record, I've only seen this happen when the second user modifies the VBA code in the workbook; not the "front end" contents of the worksheets themselves.
    Gre

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    Hi Hans,

    Going from Excel 2000 to Excel 2002, MS has changed the security. With 2000, one could sign a project using selfcert and anyone could mark that signature as being a trusted source. As from Excel XP (2002) other people can only mark certified signatures as trusted source.

    With Excel XP (and of course 2003) projects signed with selfcert indeed are only trusted on the computer that holds the selfcert certificate.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win 2K)

    Hi Jan Karel,

    Thanks for the additional info; that explains the differences reported in this thread.

  13. #13
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: 'Enable Macros' Message Disable? (Xcl 2K, Win

    Yes, I think it may be happening if they delete a worksheet which contains code. I'll investigate further. Further to Jan Karel's note on version differences, this is with 2003.
    -John ... I float in liquid gardens
    UTC -7DS

Posting Permissions

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