button disappears when column is hidden

[Edward]

I have a button that runs a macro that hides columns. I want to make
it flexible so that it can hide any column. No problems there. My
problem is that when I hide the column that my button is in, I also
hide the button. Is there a way to make buttons "float" or not assign
to any column so that I will not lose it? I am just using the
standard button created by going to View->Toolbars->Form and selecting
the button using Excel 2002.

Thanks.

Edward

 

[Dave Peterson]

Rightclick on the button
Select Format Control|Properties tab|check "don't move or size with cells"

 

[Edward]

Rightclick on the button
Select Format Control|Properties tab|check "don't move or size with cells"

Thanks. Worked like a charm.

Edward