Hey guys once again!
I am trying to produce a macro button that when pressed will turn a row I am currently in grey. This will be repeated for green, red, orange and white. I can make the button easy enough but the actual macro is proving difficult.
6 sheets long, whichever sheet I am in, I would like to click the appropriate button (easy enough) and the whole row, or even better a selection of my choice, will go that colour. The actual cells I want to change to a particulat colour are 'A' through 'O' of the active cell.
Sounds complicated but the intention is easy!
PLEASE HELP IF YOU CAN!
I am trying to produce a macro button that when pressed will turn a row I am currently in grey. This will be repeated for green, red, orange and white. I can make the button easy enough but the actual macro is proving difficult.
6 sheets long, whichever sheet I am in, I would like to click the appropriate button (easy enough) and the whole row, or even better a selection of my choice, will go that colour. The actual cells I want to change to a particulat colour are 'A' through 'O' of the active cell.
Sounds complicated but the intention is easy!
PLEASE HELP IF YOU CAN!