Changing colour of selected cell

[MrHibs]

Hi guys,

Does anybody have a code that changes the colour of the cell you currently have selected?

So for example if you selected cell b3 that cell would now be green but if you selected b4, b3 would return to it's original colour and b4 would be highlighted green.

I'm also looking for a code that will do something similar but opposed to just changing the colour of the cell it will change the colour of the entire row that cell is in.

Cheers

 

[MrHibs]

This gets round the protected sheet problem, however the cells now stay that colour even after you click onto another cell, i.e. the cell doesn't revert to white after you've clicked off.

Any ideas?

Appreciate your help by the way.

 

[abiram01]

Hi,

I guess you might have missed to declare the global variables.

Add these global variables and try..

Dim i As Integer
Dim name1 As String

Its working fine for me..

Regards,
Abhiram

 

[MrHibs]

Ah, you are indeed correct!

Works perfectly.

Thanks champ.