Row Selection Only & Deselect by Clicking Outside the Table.

[MyForcey]

Is there a way to select an entire row only within a table BUT disable individual selection of cells, disable in cell editing, disable moving of cells AND THEN be able to click anywhere outside the table to deselect that row BUT must not select another cell when doing so?

[WideBoyDixon]

You'll need to use VBA. Right click the sheet name, select "View Code" and paste this:

Please Login or Register  to view this content.

Change the "tblPolicies" to whatever the name of your table is (assuming it's an Excel table).

WBD

[MyForcey]

Hi! Thank you... Had to amend slightly, but how do I get it so that I can click anywhere outside the table and it deselects (As opposed to selecting a new cell).

Also my 1st column is allowing editing if I double click? can that be locked as well?

My code looks like this:

Please Login or Register  to view this content.

[WideBoyDixon]

This is Excel; some cell on the sheet is always selected - the cursor has to be positioned *somewhere*. The best you could do, maybe, is to hide a column and change the selected cell to be there. Or perhaps set the selection to be somewhere off screen. I noticed you removed the disabling/re-enabling of the events - just be careful you don't end up in a loop as you're changing the selection in the changing a selection code. You also hard-coded the FAC_RISKS name so you can remove the Const declaration. Here's something that will select the cell to the right of the header row if you don't select in the table and it will also prevent double-click from activating a cell edit:

Please Login or Register  to view this content.

WBD

[MyForcey]

I added the event procedures again to the 1st and it worked perfectly.

Thank you!