View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kai Smith Kai Smith is offline
external usenet poster
 
Posts: 1
Default XL97 - Log use of paste function in workbook

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