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

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

On Jun 25, 3:22 pm, Dave Peterson <peter...@verizonXSPAM.net> 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