OK. Assuming that column A is the only column you want to protect, in the attached, is a bit of macro code behind Sheet4 which handles right-clicks on that sheet.
The idea is that you select a range or ranges on the sheet, then you right-click in one of the selected ranges and it will ask you whether you want to adjust all the selected ranges to right across the sheet but excluding column A. Whichever you choose the usual right-click menu will appear, and allow you to do what you intend with the selection.
As far as I'm aware, there's no way to protect a column from deletion of some of its rows while allowing the rest of the row to be deleted, hence the my code to adjust the selected cells before operating on them.
Last edited by p45cal; 06-16-2022 at 02:00 PM.
|