I've been working on a very complicated project for over a week now, and just
have two things left to finish the thing, one of which I'm having issues with
Any help would be appreciated. I have a workbook with 80 odd worksheets. I've
created macros that will hide/unhide 2008 data, 2009 data, or show all. My
issue is how to put them in the workbook on each sheet. I've tried a combobox,
but the problem with that is that when you hide the 2008 data it moves the
box all the way to the left (which by itself would be fine), then when you
unhide these rows it stays over there. I've also tried using data validation
(as someone here suggested) but I can't figure out how to attach macros to
the selections in the drop down box in the cell. Any ideas of how to proceed?

--
Message posted via http://www.officekb.com