I
Iain King
I have a group of buttons at the top of my worksheet, over row 1. Row 1
contains the headers for the sheet, which are important as the sheet is
Autofiltered. One of the buttons activates a sort macro which turns off the
autofilter, sorts the sheet, then turns the autofilter back on. The macro
works fine, however, when the autofilter gets turned back on, it row 1 of
the sheet above the button bar, for purposes of detcting mouse clicks.
Effectively, if a user hits the sort button, he turns off the button bar.
Any way to either send the sheet to back , or bring the button bar to front?
Iain King
contains the headers for the sheet, which are important as the sheet is
Autofiltered. One of the buttons activates a sort macro which turns off the
autofilter, sorts the sheet, then turns the autofilter back on. The macro
works fine, however, when the autofilter gets turned back on, it row 1 of
the sheet above the button bar, for purposes of detcting mouse clicks.
Effectively, if a user hits the sort button, he turns off the button bar.
Any way to either send the sheet to back , or bring the button bar to front?
Iain King