On Aug 1, 3:27 pm, "Kai Smith" wrote:
Hi there

I'm a self taught VBA user, but I have a problem I just can't get over.

Basically I have a workbook (obviously) but I don't want people to paste
into it. I only want them to enter data manually. Is there any way to
do two things:

a) LOG all uses of a paste function into the spreadsheet onto a separate
sheet?
b) Disable the paste function altogether.

I want to disable the function in due course, but as people have been
asked several times not to paste into the spreadsheet, I want to know
who the culprit is.

Any help would be greatly appreciated.

Thanks

Kai

Maybe you should get a video camera and mount it right behind the
"culprits". While you're at it, get Excel 2003 or 2007 and maybe a
motion sensor and an alarm system and and and....