Hi all,

I have a ActiveX control button on my worksheet. Below it, there are 10 rwos
of which 2 are shown and the others are hidden. When the user click the
button, one more row will be shown in sequence. Definitely, the button's
position should be fixed, but it doesn't. Could you tell me how to fix it. I
have tried the "format control" dialgoue, but no use.

Clara
--
thank you so much for your help

What have you tried in the format control dialog. that is where the settings
are located.

--
Regards,
Tom Ogilvy


"clara" wrote:

> Hi all,
>
> I have a ActiveX control button on my worksheet. Below it, there are 10 rwos
> of which 2 are shown and the others are hidden. When the user click the
> button, one more row will be shown in sequence. Definitely, the button's
> position should be fixed, but it doesn't. Could you tell me how to fix it. I
> have tried the "format control" dialgoue, but no use.
>
> Clara
> --
> thank you so much for your help

Hi Tom,

I've tried all, it still doesn't work. Could you tell me more specifically?

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

> What have you tried in the format control dialog. that is where the settings
> are located.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "clara" wrote:
>
> > Hi all,
> >
> > I have a ActiveX control button on my worksheet. Below it, there are 10 rwos
> > of which 2 are shown and the others are hidden. When the user click the
> > button, one more row will be shown in sequence. Definitely, the button's
> > position should be fixed, but it doesn't. Could you tell me how to fix it. I
> > have tried the "format control" dialgoue, but no use.
> >
> > Clara
> > --
> > thank you so much for your help

The options are in the properties tab of the format control dialog.

--
Regards,
Tom Ogilvy


"clara" wrote:

> Hi Tom,
>
> I've tried all, it still doesn't work. Could you tell me more specifically?
>
> Clara
> --
> thank you so much for your help
>
>
> "Tom Ogilvy" wrote:
>
> > What have you tried in the format control dialog. that is where the settings
> > are located.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "clara" wrote:
> >
> > > Hi all,
> > >
> > > I have a ActiveX control button on my worksheet. Below it, there are 10 rwos
> > > of which 2 are shown and the others are hidden. When the user click the
> > > button, one more row will be shown in sequence. Definitely, the button's
> > > position should be fixed, but it doesn't. Could you tell me how to fix it. I
> > > have tried the "format control" dialgoue, but no use.
> > >
> > > Clara
> > > --
> > > thank you so much for your help