Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste
Hi tjh
You can clear the clipboard when the user go to sheet. But when the user disable macro's this is not working Try this event in the sheet module Private Sub Worksheet_Activate() Application.CutCopyMode = False End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tjh" wrote in message ... hello, How could I prevent my users from using the Paste funtion on a spreadsheet. Is there a function that will do this, or do you know the vba code which would prevent the user from pasting to a particular worksheet. Thank You, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming |