Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Macro to only Cut and Paste

I Want to create a code in the Worksheet_change condition, that will verify
that only Cut and Paste is allowed. For example a when a change is made to
verify that it's a Cut and Paste action and anything else is canceled or
undone.

Thank you for your help.
--
Gabriel Camarena R.
Delphi Tijuana IT Support
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Macro to only Cut and Paste

I think you are looking at a protected worksheet with a button that has code
to unprotect the sheet, cut the user's selection which sparks a sheet cnange
event with a message to select a cell for pasting the data. then the paste
action could trigger code to reset the protection. Could be a little tricky,
bu doable. I don't believe that disabling everything on the menu bar except
cut and paste would work since that does no affect the pop up menus. But it
is only an opinion.

"GCRDelphi" wrote:

I Want to create a code in the Worksheet_change condition, that will verify
that only Cut and Paste is allowed. For example a when a change is made to
verify that it's a Cut and Paste action and anything else is canceled or
undone.

Thank you for your help.
--
Gabriel Camarena R.
Delphi Tijuana IT Support

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
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro Steven Excel Programming 1 October 17th 05 08:56 AM
Copy and Paste macro needs to paste to a changing cell reference loulou Excel Programming 0 February 24th 05 10:29 AM
Cut and Paste using Macro gives paste special method error Lourens Pentz Excel Programming 3 November 21st 04 10:42 PM
Macro to Paste to specific line, and continue to Paste each time on next row not over tomkarakowski[_2_] Excel Programming 1 May 28th 04 06:50 PM
Macro to Copy/Paste then Paste to Next Line tomkarakowski Excel Programming 1 May 28th 04 01:19 AM


All times are GMT +1. The time now is 08:40 PM.

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

About Us

"It's about Microsoft Excel"