Excel Command Button disappears when AutoFilter hides the row 2

[Divercem]

I have an excel spreadsheet that has several command buttons to the right of the data which is in columns a:i. If I apply AutoFilter and select to hide data on the same row as the command button the command button gets hidden as well. I found through research that the Placement attribute 3 is for free floating. So I set the attribute to 3 but it still disappears with the line.

Thanks for your help

 

[NWBeaver]

It sounds like your button somehow still has the Placement attribute set to 1.
I ran a test and a Placement attribute of 1 will hide the button, 2 will make it move up to the top of the column, and 3 will make it float in it's original place.
Do you have some code that is resetting the attribute to 1?
It should work if the Placement attribute is really 3.

 

[SkipVought]

Hi,

In design mode, right-click the object and select format object, or something to that effect.

Select the properties tab, and in that tab choose one of the options that you do not MOVE with cells.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Divercem]

Beaver,

Thanks for your reply. I don't know why setting the value to 3 didn't work, but I tried it again after your suggestion, but it wouldn't take.

However, using Skip's suggestion, I selected all of the objects and followed his instructions and viola.

Thanks to both of you for your help.

Charlie

 

[Divercem]

Out of curiosity. Is there a way to float the control objects as the page scrolls?

 

[SkipVought]

Put your controls in a modeless UserForm, rather than on the sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}