Changes entire row to a certain color

[Darrell456]

Ok,

So im very new to the Excel thing and even newer to VBA. In fact this is the first day I even knew what VBA is! So please forgive me and a very spelled out answer would be much appreciated.

Today I have figured out how to create the button, assign the macro to it, but have no clue the correct code.

For example, I found this code on MS website that I programed to my button but even when selecting the entire line it only changes the color of that specific cell.

Please Login or Register  to view this content.

However, I need to be able to click on the row then click the button and the entire row change that color.

[shg]

Welcome to the forum.

Why not just select the row and press the Fill Color button?

[dominicb]

Good evening Darrell456

...and welcome to the forum!!

However, I need to be able to click on the row then click the button and the entire row change that color.

When you post any lines of code within the forum, please use the code tags (# button) to demark your lines of code.

Try using this line instead :

Please Login or Register  to view this content.

HTH

DominicB

[Darrell456]

Hi and thanks VERY much. That did it!!!!!

Is there a way that when the line is highlighted the grid lines and columns do not disappear? It just shows the entire line as a solid color. Not a big deal though.

Thanks again!!!

[protonLeah]

Add a new line after the previous one:

Please Login or Register  to view this content.

At the end of the line, enter a period and notice the dropdown box.
Select CELL.
Type a period, select borders [period], colorindex [=some number].

Experiment...

[Darrell456]

Here is another newb question.

I programed the buttons with the code. However when I save the workbook:

"The following features cannot be saved in Macro free workbooks"

How do I change this? Obviously I have no clue what im doing.

[Darrell456]

Nevermind I figured it out. I wonder if once I put this on my computers at work will it give the Security warning each time its open as to the Macros???

[dominicb]

Hi Darrell456

Nevermind I figured it out. I wonder if once I put this on my computers at work will it give the Security warning each time its open as to the Macros???

Yes, it will. This is just Microsoft's security thing. There is one thing you can do to get rid of it but I wouldn't recommend it.

If you were to go to Tools > Macro > Security and set your security level to "Low". This will mean that all macros could be run on your machine, without you even knowing a workbook contained macros. As I say, it's not recommended ...

HTH

DominicB