Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Paste text only

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste Special text or Unicode Text Kevin Excel Discussion (Misc queries) 4 May 18th 23 03:46 AM
cut/paste text into cells (wrap text) JoBeth Excel Discussion (Misc queries) 1 July 12th 08 12:45 AM
How paste text from note pad to excel w/o using (Text to column) f nginhong Excel Worksheet Functions 0 April 18th 06 02:07 PM
Excel is automatically doing "text to columns" upon paste text. robert10000 Excel Discussion (Misc queries) 1 June 15th 05 07:49 PM


All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"