Hi
Is There, Is There A Way To Protect My Excel File From Beeing Copied To An Unauthorised Computer
Thank You

Short answer is no - from Excel's resources. All of Excel's protection is rudimentary, and copying data from a locked/protected sheet can always be copied.

If you want to prevent someone from opening the spreadsheet, that can be done, and provides more protection (but they won't see the spreadsheet, either) than just locking the spreadsheet.

Actually, the answer is yes. You can assign persmisions to the NT folder the file is in.

I Know three ways of making this more difficult for someone

Using the Before RightClick Event
Setting Cancel to True (This Disallows the Context Menu to Pop Up)

You Could set the toolbars to be disabled
Set this in the Workbook Activate (Remeber to Enable some After the Workbook is deactivated)

you then need to stop people who know the Keyboard copy command

with the Application.onKey "^c" , "Procedurename" you can stop the control + C copy Method again remember to switch this off before you leave the workbook

you can also stop saving from file by using the
Workbook_BeforeSave Event

all these make saving and copying data more of a problem and will stop most people from copying or saving, but if you know what you are doing there are easy ways to crack the security in Excel and these procedures will not protect you against that.

Hope This Helps

David

Yep, and that was my point in the original post. But for 98% of users of Excel, these would be more than sufficient.

Hi Shades,

I thought i was had to reiterate your point because i felt it was the most important point, but some security measures is better than none at all although all i suggested was to stop someone copying data or saving from within Excel itself which is definatley not a complete soloution, even with these measures in place it is still easy to get the data out.

By all means. You were more thorough than I, which is good. I think we can't emphasize enough that "protection" in Excel is a relative thing. We fool ourselves if we think we can prevent true intrustion into an Excel file. But your laying out of the methods to foil the would-be transgressor is extremely valuable.