copy protection

C

cyclingsal

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
 
J

Jako

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 !!
 
M

Marcus

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%.
 
R

Robert McCurdy

What is the most effective way of preventing an unauthorized person
from copying an excel file
Click to expand...

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
 
Top