If you password protect the VBE it makes it harder for anyone to see the
code.
--
steveB
Remove "AYN" from email to respond
"Anne Troy" wrote in message
news:c0e8$42d574d3$97c5108d$22207@allthenewsgroups .com...
Are you saying no one can export all the code, copy the sheets to a new
book, and sign it themselves?
*******************
~Anne Troy
www.OfficeArticles.com
"Tom Ogilvy" wrote in message
...
So you saying anyone can get the code, modify it, and then certify that
they
are Bill. I think not.
--
Regards,
Tom Ogilvy
"Anne Troy" wrote in message
news:e5511$42d56e75$97c5108d$21336@allthenewsgroup s.com...
You need a Digital Signature to market something like this Bill.
http://www.verisign.com/products-ser...80041570000002
However, I don't recommend it because anyone can then copy/crack your
code
and send it to others. If you have a great idea, my recommendations
a
1) Get a web developer to make a web-based application for you, to
which
you
let users subscribe on a monthly basis.
2) If web isn't feasible, then have a VB application created from it,
or
a
COM add-in, either of which is far harder to reverse-engineer than
macros
in
an Excel workbook.
As it stands now, anybody could take your macro home, self-sign it, and
make
themselves the trusted developer at work.
*******************
~Anne Troy
www.OfficeArticles.com
"Bill Hall" wrote in message
...
My school ICT manager, although impressed with my Excel programming
(his
words, not mine!) of Interactive Whiteboard Maths Excel workbooks,
tells
me
that the school can not market them because of their use of MACROS -
(really
VBA code behind Excel). Other schools probably won't have the
courage
or
imagination to allow my macros to be used my the machines on their
networks.
I am assuming that I can't write code to "correct" their macro
security
to
"low".
What should I do? I notice a phrase "trusted macro developer" on a
dialogue
box. Could you explain what that means and how someone is credited
with
that
status.
Thanking in anticipation
Bill Hall