Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Put this code in the This Workbook Sheet in VB Editor:
Private Sub Workbook_Open() avoid End Sub Then insert a Module and type the code below in the module: Public Sub avoid() Application.OnTime Now + TimeValue("00:00:01"), "avoid" Application.CutCopyMode = False End Sub This will make cut/copy/paste almost impossible (user has 1 second to accomplish the whole thing). If you want users to be able to paste value, write a code for pasting values only which will disable application.ontime temporarily. It could be added as an right-click menu item. Too much code to put in here really. Regards -----Original Message----- Since it seems to be quite an ordeal to turn off cut/copy/paste from a user, is it possible only to allow the user to paste the cell value but not the formatting? If this is not possible, can someone tell me a good place to find code to turn off the cut/copy/paste. I have looked and didn't have alot of luck. Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste Special text or Unicode Text | Excel Discussion (Misc queries) | |||
cut/paste text into cells (wrap text) | Excel Discussion (Misc queries) | |||
How paste text from note pad to excel w/o using (Text to column) f | Excel Worksheet Functions | |||
Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) |