Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Trusted Macros (Excel 2k SR1)

    With all the posts concerning VBA in this forum, my guess is that quite a number of you write and use macros in your workbooks. What have you done, if anything, to overcome or work within Excel's macro security? The default level now has warnings popping up for more and more of my workbooks, as well as for every workbook that I design for others. (I design for non-Excel users, so push-button macros are used to control nearly all functions except for input, so these people who don't want to learn Excel don't have to.)

    For my own pc, I had felt safe enough to turn off the macro security, but I'm beginning to think that this lax attitude has to end; even moreso on the other pc's where my macro-driven workbooks are being loaded. I need a way to have Excel recognize my macros and mark them as safe to run, while retaining the higher level of macro security. Microsoft's pages linked to (non-Microsoft) sites willing to sell me a certificate for a few hundred dollars, which is completely unreasonable given the limited nature of my macro work.

    I had tried going to a site that has email certificates available for free (Digicerf)... but that site was infected with Nimda, so I'll not be hurrying back there any time soon.

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trusted Macros (Excel 2k SR1)

    David,

    I use the medium security level for macros. In our company this is the default setting. But I fully agree with you that this should be organized differently. People that use macros from a source that can be trusted should not always be warned about the fact that the workbook contains macros. Excel should allow to make a difference between macros that have proved to be OK and new macros, which have to be used for the first time and can contain viruses. I don't know of any certificates for free, but it's something that should be built in for free. At least, that's how I feel about it.

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

    Re: Trusted Macros (Excel 2k SR1)

    For my own workbooks that include macros I use SelfCert from Microsoft that allows me to create my own certification certificate. You can also send that to others that you send workbooks to if you can convince them to trust the certification. SelfCert comes with Office 2K. You might have to get the developers edition of 97 to get it.

    Since I download a lot of workbooks from this forum, I keep my security on and click on disable the first time I open a workbook until I visually check out any macros.
    Legare Coleman

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Trusted Macros (Excel 2k SR1)

    SelfCert? I have been using O2K Pro and have never heard of it. Would it be something that I have loaded already? When I installed, I set the suite to run from my HD, but only Disk 1, not both.

  5. #5
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trusted Macros (Excel 2k SR1)

    Q217221 OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
    may help.

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Trusted Macros (Excel 2k SR1)

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=48090&page=&v iew=&sb=&o=&vc=1#Post48090>Rory's post #48090</A> pointed me to the SelfCert.exe file, but initial tests did not change anything. I'll be checking out those two KB articles shortly, and hopefully they'll shed some light on the matter.

  7. #7
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Trusted Macros (Excel 2k SR1)

    I've used SelfCert to create a digital signature, and have gotten it to work with Excel to open up some macro-loaded workbooks without any security prompting. <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

    I know that I'll have to root out all of my previously-written macros to sign them with this certificate, but is there a way for me to set VBA's defaults to sign all of my new macros with this certificate?

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

    Re: Trusted Macros (Excel 2k SR1)

    No, it is the workbook you are signing, and you have to sign each one.
    Legare Coleman

Posting Permissions

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