button disappears when column is hidden
 

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

button disappears when column is hidden
 

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



Edward wrote:

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

button disappears when column is hidden
 

On Jun 25, 3:22 pm, Dave Peterson wrote:
Rightclick on the button
Select Format Control|Properties tab|check "don't move or size with cells"

Edward wrote:

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

Thanks. Worked like a charm.

Edward