how do I become reliable?

  • Thread starter Thread starter Henning
  • Start date Start date
H

Henning

anyone knows how to add myself as a reliable source, so I will not get the
warning everytime I open a workbook with macroes?

TIA
Henning
 
Henning

You can create a digital certificate and use that on your VBAProject so only
that file with the certificate is allowed to be opened with no warning.

You can get to SelfCert either of these ways........

1. Start>Programs>Microsoft Office>Tools>"Digitasl Certificate for VBA
Projects"

2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.

This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.

OK your way out and save your file.

Next time you open this particular file you will not get the warning.

NOTE: DC's are not available for Excel 97

Gord Dibben Excel MVP
 
Yes! - Thank you
Henning

Gord Dibben said:
Henning

You can create a digital certificate and use that on your VBAProject so only
that file with the certificate is allowed to be opened with no warning.

You can get to SelfCert either of these ways........

1. Start>Programs>Microsoft Office>Tools>"Digitasl Certificate for VBA
Projects"

2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.

This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.

OK your way out and save your file.

Next time you open this particular file you will not get the warning.

NOTE: DC's are not available for Excel 97

Gord Dibben Excel MVP
Click to expand...
 
Henning

Thanks for the feedback.

Some posters have reported problems with the selfcert. Good to hear this info
worked for you(as it has for me).

Gord
 
Back
Top