Modification required in vba code.

Dear Members,

I have below VBA code behind the sheet, which highlights the row of the selected cell with interior colour. Is any other option to highlight the row of selected cell instead of Interior colour.

Please Login or Register  to view this content.

First question, Why do you not want to use Interior color?

Dear JapanDave,

Because I use the Background colour to cell in the sheet for record purpose.
(VBA Code ) It removes this background colour after selecting on it which I did manually.

eg. I have already set background colour to A1 cell. If I click on A1 and then click other cell A1's Background colour removes which I need for record purpose.

Hi members,

How can I use below code

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

I don't quite understand what you want?

Sir,

I have code (post #1) for

Highlight the entire row of the selected cell temporery.
Eg. If I click on B2 cell the 2nd row should be highlighted same manner for other cell.

It works nice but I want little modification this code to borders to enter row(Top and Bottom)

Hope you will understand my problem.

See if this is what you want.

Please Login or Register  to view this content.

Yes !!!!!! that's it,

It should Bold line, should it possible?

Try this,

Please Login or Register  to view this content.

Yes!!!!! It works perfect

Thank you JapanDave

Dear JapanDave,

I am using the code, but now I noticed one error during the working with this sheet.

I am unable to Copy and Paste any range

Yeah, that can be a pain with event macros sometimes.

Please Login or Register  to view this content.

done

Thank you for helping me out.