Hi,
What is the most effective way of preventing an unathorized person
from copying an excel file (that may contain sensitive/confidential
information) onto a disk and using it in elsewhere (different computer
i.e. at home). My thought would be to have a macro check the computer
ID and disabling macro form unhiding sheets. Is there a better way?

Thanks
Sal

I'm no MVP but from what i have gathered.....

Obviously when Excel starts it asks if you want to disable macros.
Therefore any Macro driven protection would not execute if the use
disables macros.

In my experience anyway even VBA that is hidden and password protecte
can still be got at by anyone with a little know how or an exce
password remover application (of which many are commerciall
available).

I don't think there is anyway to make any excel file completel
secure.

These are only my thoughts but i'm sure an expert will reply to you
post shortly.

Remember Big Brother is watching you and mark my WORD he has ACCESS t
your EXCELlent files. The OUTLOOK is bleak !!

--
Message posted from http://www.ExcelForum.com

I would:
a)Password Protect VBA within VB Module which makes the
coding almost 95% save.

b) use a password command to launch yur first userform

c)use useforms to capture infomation to a protect
worksheet.

In conjuction the 3 rules should make your data and code
reasonable save but your never 100%.


-----Original Message-----
I'm no MVP but from what i have gathered.....

Obviously when Excel starts it asks if you want to
disable macros.
Therefore any Macro driven protection would not execute
if the user
disables macros.

In my experience anyway even VBA that is hidden and
password protected
can still be got at by anyone with a little know how or
an excel
password remover application (of which many are
commercially
available).

I don't think there is anyway to make any excel file
completely
secure.

These are only my thoughts but i'm sure an expert will
reply to your
post shortly.

Remember Big Brother is watching you and mark my WORD he
has ACCESS to
your EXCELlent files. The OUTLOOK is bleak !!!


---
Message posted from http://www.ExcelForum.com/

.

What is the most effective way of preventing an unauthorized person
from copying an excel file

Well there are a number of ways that spring to mind..
1 Stand behind him/her
2 Cut their fingers off?
3 Use Excel version 1
4 Have them sign a secrecy clause with their blood, and insist thats just tradition.
5 Adjust the TV set, so they can see themself on there.
6 Install a new Office assistant, and ignore their pleas, when told to use the one named HAL.
7 Take away the monitor.
8 Bring back mini skirts.
9 Create an On Key event macro that runs when ever Ctrl + C is pressed - that basically says "Your Fired" using speaking cells.
10 Let the user find some putty under the chair, and wrapping paper with the words "C4 - do not wear", on it.


Regards Robert

"cyclingsal" wrote in message om...
Hi,
What is the most effective way of preventing an unathorized person
from copying an excel file (that may contain sensitive/confidential
information) onto a disk and using it in elsewhere (different computer
i.e. at home). My thought would be to have a macro check the computer
ID and disabling macro form unhiding sheets. Is there a better way?

Thanks
Sal


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004