Highlight Button

[simonplus]

Hi there,

I have 7 columns in a sheet for each day of the week (each separated by a blank column) and would like to create a macro that would allow the user to highlight the cells of the column in use at the click of a button.

A highlight button is at the top of each column. The Monday column has the following range (E9:E49).

I would also like to place another button at the bottom of each column ("Completed") to change back the color of the column to the original one (white) when the data entry process is completed without deleting the data entered.

I would appreciate your help.

S

[Mumps1]

The days of the week are in columns E to Q, every second column. Is this correct? Do all days have the same range, from row 9 to row 49? Is this range constant or can it change? When you say

highlight the cells of the column in use

do you mean all the cells in the range, that is from row 9 to row 49?