Hiding a button when hiding rows

Hi Guys,

Can someone help me out. I'm trying to hide some rows and some of
these rows have buttons on the cells.

When I hide the rows that buttons just all bunch up and stay visible.

Is it possible to associate the button with a cell and hide the button
when the rows are hiden?

Thanks,
Richard.

In design mode, right click on the button and select Format
Control>Properties>Move and size with cells, then OK it.

--
Ian
--
<[email protected]> wrote in message
news:[email protected]...
> Hi Guys,
>
> Can someone help me out. I'm trying to hide some rows and some of
> these rows have buttons on the cells.
>
> When I hide the rows that buttons just all bunch up and stay visible.
>
> Is it possible to associate the button with a cell and hide the button
> when the rows are hiden?
>
> Thanks,
> Richard.
>

By "design mode" do you mean Normal view mode, as opposed to "View Page
Breaks" mode?

"Ian" wrote:

> In design mode, right click on the button and select Format
> Control>Properties>Move and size with cells, then OK it.
>
> --
> Ian
> --
> <[email protected]> wrote in message
> news:[email protected]...
> > Hi Guys,
> >
> > Can someone help me out. I'm trying to hide some rows and some of
> > these rows have buttons on the cells.
> >
> > When I hide the rows that buttons just all bunch up and stay visible.
> >
> > Is it possible to associate the button with a cell and hide the button
> > when the rows are hiden?
> >
> > Thanks,
> > Richard.
> >
>
>
>

Design mode is found on the Control Toolbox.

Ian has made the assumption that Richard's buttons were created using the
Control Toolbox.


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 10:20:01 -0700, Traveller
<[email protected]> wrote:

>By "design mode" do you mean Normal view mode, as opposed to "View Page
>Breaks" mode?
>
>"Ian" wrote:
>
>> In design mode, right click on the button and select Format
>> Control>Properties>Move and size with cells, then OK it.
>>
>> --
>> Ian
>> --
>> <[email protected]> wrote in message
>> news:[email protected]...
>> > Hi Guys,
>> >
>> > Can someone help me out. I'm trying to hide some rows and some of
>> > these rows have buttons on the cells.
>> >
>> > When I hide the rows that buttons just all bunch up and stay visible.
>> >
>> > Is it possible to associate the button with a cell and hide the button
>> > when the rows are hiden?
>> >
>> > Thanks,
>> > Richard.
>> >
>>
>>
>>

Thanks for clearing that up, Gord.

"Gord Dibben" wrote:

> Design mode is found on the Control Toolbox.
>
> Ian has made the assumption that Richard's buttons were created using the
> Control Toolbox.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 9 Aug 2006 10:20:01 -0700, Traveller
> <[email protected]> wrote:
>
> >By "design mode" do you mean Normal view mode, as opposed to "View Page
> >Breaks" mode?
> >
> >"Ian" wrote:
> >
> >> In design mode, right click on the button and select Format
> >> Control>Properties>Move and size with cells, then OK it.
> >>
> >> --
> >> Ian
> >> --
> >> <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Hi Guys,
> >> >
> >> > Can someone help me out. I'm trying to hide some rows and some of
> >> > these rows have buttons on the cells.
> >> >
> >> > When I hide the rows that buttons just all bunch up and stay visible.
> >> >
> >> > Is it possible to associate the button with a cell and hide the button
> >> > when the rows are hiden?
> >> >
> >> > Thanks,
> >> > Richard.
> >> >
> >>
> >>
> >>
>
>