A way to prevent ctrl-c and ctrl-v within a cell?

[ChrisPetersen77]

For legal reasons I need my employees to not copy/paste information on their reports. I have successfully used macros to prevent all copy or paste functions from working when cells are highlighted- yet I don't seem to find a way to prevent copy and paste when data is being entered into cells. Is there such a way with macros?

I cannot follow the route of protecting pages as I need these employees to be able to enter data into these cells (in ways that may be unique so I can't work around this with a drop down menu)

Thanks!

[mehmetcik]

Hi

I think this is so simple that you will kick yourself.

Create two new macros Like:

Please Login or Register  to view this content.

Under Macro options set one to run when you press Ctrl and C, the second when you press Ctrl and V.

I guess if you put these macros into each persons personal workbook then they cannot use Ctrl C and Ctrl V on any workbook.

[jaslake]

Hi Chris

Perhaps something like this in the ThisWorkbook Module...

Please Login or Register  to view this content.

[xladept]

Check this out.