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 |
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 |
All times are GMT +1. The time now is 09:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com