Can I "sign" my own macros? or some other fix for the message about security and macros?
 

I have several macros I have created and I would like to have high security,
or at least medium, but I don't like excel asking me each time I start about
the "Enable/Disable Macros." is there a way I can tell Excel that these
macros are OK?

Thanks
Bruce

Can I "sign" my own macros? or some other fix for the message about security and macros?
 

The reason for the macro warning is that its fairly easy to write malicious
code that will damage another persons computer, ie Viruses. The warning
cannot be turned off for this reason, it runs first before anything else is
shown, if it could be turned off the sad Virus writing fraternity would have
a field day as they would be able to do it via VBA code and infect your
machine without any warning or consent.

"BruceJ" wrote in message
news:YWUpb.76762$mZ5.490359@attbi_s54...
I have several macros I have created and I would like to have high
security,
or at least medium, but I don't like excel asking me each time I start
about
the "Enable/Disable Macros." is there a way I can tell Excel that these
macros are OK?

Thanks
Bruce

Can I "sign" my own macros? or some other fix for the message about security and macros?
 

Alan,

I believe you can sign your own macros. Look under help for "Create your
own digital certificate".

If you plan to have your macros run on other computers, you might want to
purchase a digital certificate from Verisign or one of other vendors.

I don't know much about Digital Certificates, so perhaps others can join in
and assist.

Best regards,
Kevin



"Alan" wrote in message
...
The reason for the macro warning is that its fairly easy to write
malicious
code that will damage another persons computer, ie Viruses. The warning
cannot be turned off for this reason, it runs first before anything else
is
shown, if it could be turned off the sad Virus writing fraternity would
have
a field day as they would be able to do it via VBA code and infect your
machine without any warning or consent.

"BruceJ" wrote in message
news:YWUpb.76762$mZ5.490359@attbi_s54...
I have several macros I have created and I would like to have high
security,
or at least medium, but I don't like excel asking me each time I start
about
the "Enable/Disable Macros." is there a way I can tell Excel that these
macros are OK?

Thanks
Bruce

Can I "sign" my own macros? or some other fix for the message about security and macros?
 

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

use SelfCert

--
Regards,
Tom Ogilvy



"BruceJ" wrote in message
news:YWUpb.76762$mZ5.490359@attbi_s54...
I have several macros I have created and I would like to have high
security,
or at least medium, but I don't like excel asking me each time I start
about
the "Enable/Disable Macros." is there a way I can tell Excel that these
macros are OK?

Thanks
Bruce

Can I "sign" my own macros? or some other fix for the message about security and macros?
 

I tried this selfcert thing, but how do I tell Office that I am "Dave" (who
I created the certificate for) and it's ok to automatically open files that
have macros by "Dave". Trusted sources apparently doesn't let me add any
names.


"Tom Ogilvy" wrote in message
...

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

use SelfCert

--
Regards,
Tom Ogilvy



"BruceJ" wrote in message
news:YWUpb.76762$mZ5.490359@attbi_s54...
I have several macros I have created and I would like to have high
security,
or at least medium, but I don't like excel asking me each time I start
about
the "Enable/Disable Macros." is there a way I can tell Excel that these
macros are OK?

Thanks
Bruce

Can I "sign" my own macros? or some other fix for the message about security and macros?
 

Dave,

I just tried this for the first time after reading the above posts. In VBE
under tools, I clicked Digital Signatures and chose the signature. The
first time I opened thenworkbook I got a dialog box that offers the option
to "always trust files from this source" or something like that. I chose
that option and mow the workbook just opens with no macro dialogs.

hth,

Doug

"Dave R." wrote in message
...
I tried this selfcert thing, but how do I tell Office that I am "Dave"
(who
I created the certificate for) and it's ok to automatically open files
that
have macros by "Dave". Trusted sources apparently doesn't let me add any
names.


"Tom Ogilvy" wrote in message
...

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

use SelfCert

--
Regards,
Tom Ogilvy



"BruceJ" wrote in message
news:YWUpb.76762$mZ5.490359@attbi_s54...
I have several macros I have created and I would like to have high
security,
or at least medium, but I don't like excel asking me each time I start
about
the "Enable/Disable Macros." is there a way I can tell Excel that
these
macros are OK?

Thanks
Bruce

Can I "sign" my own macros? or some other fix for the message about security and macros?
 

Works great! Thanks Doug!

"Doug Glancy" wrote in message
...
Dave,

I just tried this for the first time after reading the above posts. In
VBE
under tools, I clicked Digital Signatures and chose the signature. The
first time I opened thenworkbook I got a dialog box that offers the option
to "always trust files from this source" or something like that. I chose
that option and mow the workbook just opens with no macro dialogs.

hth,

Doug

"Dave R." wrote in message
...
I tried this selfcert thing, but how do I tell Office that I am "Dave"
(who
I created the certificate for) and it's ok to automatically open files
that
have macros by "Dave". Trusted sources apparently doesn't let me add any
names.


"Tom Ogilvy" wrote in message
...

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA
Projects
(Q217221)

use SelfCert

--
Regards,
Tom Ogilvy



"BruceJ" wrote in message
news:YWUpb.76762$mZ5.490359@attbi_s54...
I have several macros I have created and I would like to have high
security,
or at least medium, but I don't like excel asking me each time I
start
about
the "Enable/Disable Macros." is there a way I can tell Excel that
these
macros are OK?

Thanks
Bruce

Can I "sign" my own macros? or some other fix for the message about security and macros?
 

Tom, I can not find "Selfcert" I DO have a MAKECERT that was installed when
I followed the steps listed. Is this the same?

Bruce

"Tom Ogilvy" wrote in message
...

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

use SelfCert

--
Regards,
Tom Ogilvy



"BruceJ" wrote in message
news:YWUpb.76762$mZ5.490359@attbi_s54...
I have several macros I have created and I would like to have high
security,
or at least medium, but I don't like excel asking me each time I start
about
the "Enable/Disable Macros." is there a way I can tell Excel that these
macros are OK?

Thanks
Bruce

Can I "sign" my own macros? or some other fix for the message about security and macros?
 

Oppps.....
I did find it!
Sorry! It worked like a charm as advertised!

Bruce

"BruceJ" wrote in message
news:TGgqb.86879$9E1.438360@attbi_s52...
Tom, I can not find "Selfcert" I DO have a MAKECERT that was installed
when
I followed the steps listed. Is this the same?

Bruce

"Tom Ogilvy" wrote in message
...

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

use SelfCert

--
Regards,
Tom Ogilvy



"BruceJ" wrote in message
news:YWUpb.76762$mZ5.490359@attbi_s54...
I have several macros I have created and I would like to have high
security,
or at least medium, but I don't like excel asking me each time I start
about
the "Enable/Disable Macros." is there a way I can tell Excel that
these
macros are OK?

Thanks
Bruce