Okay sure. In this case, what does 'activate' mean? Do they change colour, become selected, or something else? I think if you attach an example workbook then we should be able to come up with an answer quite quickly.

__________________
Colin

RAD Excel Blog