Hi
There really is no way to prevent copying in excel.
There are several things you can do to make it more difficult for the
average user, like deleting the cut,copy and paste items from the menu bars,
using onkey to disable the shortcut keys from cutting, copying and pasting,
disabling the right click menu, password protecting your vba code and having
all sheets but the opening sheet xlveryhidden so macros must be enabled etc
but still anyone with a little vba programming knowledge and a little
initiative can bypass all of that in a few minutes.
I have a workbook that shows how to do all of these things, but like I say
it is not very practical since it can still all be bypassed fairly easily.
If you want to see it for information's sake, email me and I will send you a
copy.
Ken
