Our company has created a program in MS Excel 2003. We plan on disturbing
the program to our salesman to assist in their sales. We have some sensitive
information in the program. I know how to password protect sheets and make
Excel Read-Only. My Question is there anyway to stop a person from Coping or
Emailing the program to anther person or Computer. We plan on distributing
the program in the safest way possible for the company.

Hi Josh

There is no way to stop a person from Coping or Emailing
With code you can do it but a user can disable the macro's

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Josh C" wrote in message ...
Our company has created a program in MS Excel 2003. We plan on disturbing
the program to our salesman to assist in their sales. We have some sensitive
information in the program. I know how to password protect sheets and make
Excel Read-Only. My Question is there anyway to stop a person from Coping or
Emailing the program to anther person or Computer. We plan on distributing
the program in the safest way possible for the company.

thanks for the input, that is kind of what i am hearing form everyone i ask.

"Ron de Bruin" wrote:

Hi Josh

There is no way to stop a person from Coping or Emailing
With code you can do it but a user can disable the macro's

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Josh C" wrote in message ...
Our company has created a program in MS Excel 2003. We plan on disturbing
the program to our salesman to assist in their sales. We have some sensitive
information in the program. I know how to password protect sheets and make
Excel Read-Only. My Question is there anyway to stop a person from Coping or
Emailing the program to anther person or Computer. We plan on distributing
the program in the safest way possible for the company.

I'm not sure how to prevent e-mailing and/or copying, but you might be
able to at least code something so that the first time someone opens
the spreadsheet, that it logs their userid into a hidden column (or
otherwise hidden location somewhere in the document.
Then, at least, if you find the document somewhere that it shouldn't
be, you might be able to determine who originally had it and gave it
away. At least maybe there'd be an audit trail.

I hope you can find out how to do what you want, and hope that
whatever solution you come up with, that you will post it here.
Thanx.

Josh C wrote:
Our company has created a program in MS Excel 2003. We plan on disturbing
the program to our salesman to assist in their sales. We have some sensitive
information in the program. I know how to password protect sheets and make
Excel Read-Only. My Question is there anyway to stop a person from Coping or
Emailing the program to anther person or Computer. We plan on distributing
the program in the safest way possible for the company.

thanks for the idea, we have not been able to find a way and are leaning
toward developing a key that will have to match the computer the program is
running on.

"HockeyFan" wrote:

I'm not sure how to prevent e-mailing and/or copying, but you might be
able to at least code something so that the first time someone opens
the spreadsheet, that it logs their userid into a hidden column (or
otherwise hidden location somewhere in the document.
Then, at least, if you find the document somewhere that it shouldn't
be, you might be able to determine who originally had it and gave it
away. At least maybe there'd be an audit trail.

I hope you can find out how to do what you want, and hope that
whatever solution you come up with, that you will post it here.
Thanx.

Josh C wrote:
Our company has created a program in MS Excel 2003. We plan on disturbing
the program to our salesman to assist in their sales. We have some sensitive
information in the program. I know how to password protect sheets and make
Excel Read-Only. My Question is there anyway to stop a person from Coping or
Emailing the program to anther person or Computer. We plan on distributing
the program in the safest way possible for the company.

Sorry it took so long to reply, but this has been a difficult problem to
solve. I have not found anything in Excel, however I have found a system that
assist MS Office 2003 and newer. The system is Information Rights Management
(IRM) technology. There are some requirements to use IRM. Here are two
websites that explain the system better:
http://office.microsoft.com/en-us/ex...098061033.aspx
http://www.microsoft.com/technet/tec...e/Default.aspx
I have just started the process of integrating this some wish me luck.


"HockeyFan" wrote:

I'm not sure how to prevent e-mailing and/or copying, but you might be
able to at least code something so that the first time someone opens
the spreadsheet, that it logs their userid into a hidden column (or
otherwise hidden location somewhere in the document.
Then, at least, if you find the document somewhere that it shouldn't
be, you might be able to determine who originally had it and gave it
away. At least maybe there'd be an audit trail.

I hope you can find out how to do what you want, and hope that
whatever solution you come up with, that you will post it here.
Thanx.

Josh C wrote:
Our company has created a program in MS Excel 2003. We plan on disturbing
the program to our salesman to assist in their sales. We have some sensitive
information in the program. I know how to password protect sheets and make
Excel Read-Only. My Question is there anyway to stop a person from Coping or
Emailing the program to anther person or Computer. We plan on distributing
the program in the safest way possible for the company.