How to turn off excel warning at startup..
Posted by Johny on January 22, 2001 4:10 AM
whenever i opened my excel files, this warning will
appear, "whether i want to disble macros or to enable
macros"
This warning is pretty annoying..can some1 tell me
to to shut off this thing for sure? thanks
Posted by Greg on January 22, 2001 7:00 AM
To turn of the macro warning you have to sign a macro and then trust the source of the signature. In the office files there should be a file called SelfCert. This is the file that you need to open and make a certificate for yourself. After you do that, you should be able to go into the visual basic editor and sign the macro.
Posted by Johny on January 22, 2001 1:22 PM
What do u mean by sign..could u be more specific..
Posted by GREG on January 22, 2001 1:50 PM
Re: What do u mean by sign..could u be more specific..
Did you find the SelfCert in the office files? If you have found that go to Tools>Macro>VisualBasic Editor>Tools>DigitalSignature>Choose. If you have already found the SelfCert and made a certificate then there should be a certificate name in the box. Highlight that and you should be good to go. I don't remember if you have to choose to install Selfcert when you install office.
