Suppress macro warning on my own workbooks?

[Stan Brown]

Excel 2003, macro security level Medium

This means that I get the macro warning when I open my own workbooks.
Is there any way around that, short of paying Verisign or someone for
a digital signature? I'd like to be prompted with a macro warning
when I open other folks' workbooks but not when I open my own.(*)

Or is there an inexpensive way for private individuals to get and
apply digital signatures?

(*) I know that Excel can't know which macros are "my own" without a
digital signature. But I'm talking about fewer than half a dozen
workbooks, so if I could list them by path and filename that would be
just fine.

 

[Nick Hodge]

Stan

You may have to adapt your code slightly but if you save them as add-ins and
load them into Excel (Tools>add-ins..) then you get no warning

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Dave Peterson]

Open excel and search for: selfcert

You'll see instuctions there.

 

[Stan Brown]

Sat, 24 Mar 2007 09:50:12 -0500 from Dave Peterson

Open excel and search for: selfcert

You'll see instuctions there.

Perfect! Thanks very much.

(A lot of times, the feature one wants is already there, but the hard
part is knowing what it's called.)