Thread: Macros Security
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
 
Posts: 221
Default Macros Security

If you say so.
*******************
~Anne Troy

www.OfficeArticles.com


"Tom Ogilvy" wrote in message
...
He never asked about protecting his code. He asked about a trusted
developer and implied he wanted his code to open with a macro prompt. You
introduced concern about protecting the code. No one suggested

distributing
the code with nothing but a certificate. You have mixed two different
topics together as Harald illuminated.

--
Regards,
Tom Ogilvy

"Anne Troy" wrote in message
news:6fed4$42d5a3b2$97c5108d$23863@allthenewsgroup s.com...
Where did anyone ever get the idea that I was telling him people could

hack
his signature? I never said that. He said that "the school can not

market
them..." This tells me he wants to SELL it. Sorry, but I would never

SELL
any Excel product that only has a digital signature.
*******************
~Anne Troy

www.OfficeArticles.com



"Harald Staff" wrote in message
...
Anne

There are two very different issues he Protecting code from

thieves,
and
signing code so that it can be allowed to run in schools computers. A
signature is no protection against theft, it is a "run me without

further
questions, I'm from a trusted programmer" label. Any good hacker can

steal
the code, but the signature in question can not be hacked or imitated

from
the file as far as I know.

HTH. Best wishes Harald

"Anne Troy" skrev i melding
news:ebb9f$42d578d6$97c5108d$22631@allthenewsgroup s.com...
My point exactly. So if the OP is wanting to SELL his technology,
digitally
signing it really buys him no protection at all. Is that correct?
*******************
~Anne Troy

www.OfficeArticles.com


"ben" (remove this if mailing direct) wrote in

message
...
well certainly they can sign it themselves ann. But without BILL'S
certificate they can either only sign with a self-made certificate

or
with
their own purchased certificate.
--
When you lose your mind, you free your life.


"STEVE BELL" wrote:

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