Bruce,

If you have one button and a frozen first row, then the button isn't really part of the rows of
data, just part of the top row. Do you want to use the inputbox version, and then have Excel scroll
to that row? Or do you want to select a single cell in the row (manually scrolling to it) and then
have Excel select the data from the row? (I'm not really sure what you want when you say 'activate
the row'. What row?)

HTH,
Bernie
MS Excel MVP


"Bruce Neylon" wrote in message
k.net...
I can live with this. :-) Thank you very much.

One step further, is there a way to make clicking the button activate the row? Or is the button,
not really part of the row?

Again, Thanks,
Bruce