ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I run my spreadsheet on someone else's computer? (https://www.excelbanter.com/excel-programming/339624-how-can-i-run-my-spreadsheet-someone-elses-computer.html)

Mac Lingo[_2_]

How can I run my spreadsheet on someone else's computer?
 
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[_4_]

How can I run my spreadsheet on someone else's computer?
 
Excel doesn't usually spread diseases unless infected by a virus. Care to
explain your question further?

--
Don Guillett
SalesAid Software

"Mac Lingo" wrote in message
ink.net...
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





Mac Lingo[_2_]

Clarification: How can I run my spreadsheet on someone else's computer?
 
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[_7_]

How can I run my spreadsheet on someone else's computer?
 
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[_2_]

How can I run my spreadsheet on someone else's computer?
 
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

Clarification: How can I run my spreadsheet on someone else's computer?
 
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)

--
Regards,
Tom Ogilvy



"Mac Lingo" wrote in message
.net...
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





Mac Lingo[_2_]

Here is one way to do it, but there has to be a better approach.
 
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

Here is one way to do it, but there has to be a better approach.
 
http://support.microsoft.com/default...b;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.

--
Regards,
Tom Ogilvy



"Mac Lingo" wrote in message
ink.net...
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






All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com