Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | Excel Programming | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
Cut and Paste using Macro gives paste special method error | Excel Programming | |||
Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming |