How can I run my spreadsheet on someone else's computer?

[Mac Lingo]

Or to put it another way, how do I get the second computer to think that my
program is not a pathogen?

Tnx,
Mac Lingo
Berkeley, CA

 

[Don Guillett]

Excel doesn't usually spread diseases unless infected by a virus. Care to
explain your question further?

 

[Mac Lingo]

When I take my spreadsheet over to the other computer, it sets off the
Security alarms.
I am not writing a super application so I don't want to pay for a
"Certificate", but how do I tell the computer that my spreadsheet is benign
in that enviornment. Or to put it another way, how do I get my program to
run without setting off the other computer's security alarms.

Tnx,
Mac

 

[tom]

Or to put it another way, how do I get the second computer to think that my

program is not a pathogen?

Have you tried Tools > Options > Security > Macro Security, and setting
it lower?

 

[Mac Lingo]

Yes, I know about setting the security lower,
But it isn't my computer, so I'd like to be able to run my program on his
computer
without changing his security settings.

Tnx,
Mac

 

[Tom Ogilvy]

Possibly use selfcert.

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)

 

[Mac Lingo]

Tom,

How do you know so much about Excel? Anyway, I appreciate it.

I have looked at the SelfCert stuff before, but it is a part of Office 2000.
I'm running Office 2003 and it isn't included on my disk.

I have found that by being on the new computer, I can copy the VB Code from
my spreadsheet to a new spread sheet on that computer and then run it there.
But

Isn't there a more elegant way to do this besides having to go to the
expense of buying a Certificate?

Mac
Berkeley, CA

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;820738

Indicates that selfcert is supported in xl2003. Perhaps it didn't get
installed.

It sounds like security is set to high on the new computer. If you set it
to medium, then the user will be prompted whether they want to disable
macros or not and can choose not to disable them.