Hiding the AutoFilter drop down.

[jessedh]

I have a set of macros that use autofilter to show a specified list a records based on criteria. I linked them up to buttons on the worksheet, and they work fine except....

1) I want to be able to hide the autofilter drop down lists so that it looks cleaner and less confused.

2) The list of buttons also gets filter and jumbled. Is ther anyway for it to essentially 'float' so that all the buttons are visible after the filter?

Thanks!
Jesse

 

[jessedh]

Hi! figured it out myself.

Just made the buttons not to resize with cells, and if you add VisibleDropDown:=False to the VB code it hides the dropdowns...