PDA

View Full Version : Solved: Autofilter problem



U_Shrestha
04-08-2008, 11:26 AM
In my attached sheet, I have embedded small commandbuttons directly in sheet1. When I apply filter, the commandbutton other than what was filtered keeps showing up.

Am I doing what shouldn't be done or do I need to change any property so that only the commandbuttons for filtered list shows up? I am using Excel 2003. Thanks.

MikeO
04-08-2008, 11:40 AM
1. Right click on the buttons and go to "Format Control".
2. Go to "Properties"
3. Click on "Move and size with cells"
4. Click "OK"

lucas
04-08-2008, 11:42 AM
Try this:
right click on each button and select format control
select the properties tab and choose the radio button that says: move and size with cells

worked for me.....

lucas
04-08-2008, 11:43 AM
Mike, I must have been typing too slow.

U_Shrestha
04-08-2008, 11:44 AM
I used that feature "move but don't size with cells" for all the buttons, but doesn't work for me. Is there a workaround? Is it because I am using Excel 2003?

lucas
04-08-2008, 11:58 AM
no, I am using 2003 and it works for me.....I will post your file back for you in a minute.

lucas
04-08-2008, 12:07 PM
this works on my 2003

U_Shrestha
04-08-2008, 12:15 PM
Hello Lucas,

Your attachment worked for me as well, but when I open the original file, then it doesn't work for me :banghead:

Thanks.

U_Shrestha
04-08-2008, 12:20 PM
Ok, I chose "Move and size with cells" and it works. I will live with it for now. Thank you all :)

lucas
04-08-2008, 12:25 PM
Hey U, be sure to mark it solved.

use thread tools at the top of the page

U_Shrestha
04-08-2008, 12:30 PM
I know, you are too fast :)