How to unselect a row within a range?

[superlative]

I allow the user to select a bunch of cells, and then perform operations on the rows of those cells. However there is a certain row that I want to unselect automatically if it is selected.

I have a custom shortcut menu that appears when the user right clicks on the selected rows: when the user right-clicks, and one of the cells selected is in the "forbidden row" - then I want cells in the forbidden row to be unselected. How do I do this?

I have looked online to find out how to unselect a range, but it only shows how to unselect the entire selected range, and not just a subset of the selected range.

Thanks!

[Mrrrr]

How do you "allow" the user to select a bunch of cells?

I'm assuming in Format Cells - Protection tab you have "Locked" unchecked. And then you password protect the sheet.
If so, then when you password protect the sheet you could uncheck "Select locked cells" - this will prevent selecting the "forbidden row" altogether, without the need to "unselect".

[superlative]

Thanks but is there another way without using the lock cells? User can select a bunch of cells by holding down Cntrl key and selecting a bunch of cells.

[Mrrrr]

Put the next code in the Sheet code to prevent users from selecting any cell in row 4:

Please Login or Register  to view this content.

[Andy Pope]

In the example the named range, IGNORE_CELLS, can not be selected

Please Login or Register  to view this content.

[Rick Rothstein]

Here is a ThisWorkbook_SheetSelectionChange event procedure (so it works on any sheet in the workbook) posted by snb here...

http://dailydoseofexcel.com/archives...e-of-the-same/

that lets you hold down the CTRL key while "selecting" a cell or range to deselect within a larger selected area. It works although it is not terribly fast for large selections (think selecting an entire column and then CTRL clicking the header cell... a comment I made in the cited blog article) but it does seem to work.

Please Login or Register  to view this content.

[superlative]

In the example the named range, IGNORE_CELLS, can not be selected

Please Login or Register  to view this content.

Thanks Everyone! I think this brilliant piece of code from Andy Pope will suit my needs!!!

for my purposes, I am only concerned with rows, so I would modify this line:
For Each cell In Target.Cells to 'For Each cell In Target.Rows', and I would put a condition that this would not trigger if the user had selected a column (I have code that detects what the user has selected: rows, columns or cells)

This is brilliant!! Thanks!

(tested this and it works beautifully. What an elegant and fast and efficient piece of code!!!)