I have a few command buttons on the spreadsheet to let user does somethign
different.


I wanted to align, resize and equal space between contros.
I can not find anything like MS Access align and size manual to use.

Any way to make this tasks easier using Ms Excel?


Your help is great appreciated,

Bring up the drawing toobar. If you click on the Draw button one of the
options is Align or Distribute....

I think that is what you want.
--
HTH...

Jim Thomlinson


"Souris" wrote:

> I have a few command buttons on the spreadsheet to let user does somethign
> different.
>
>
> I wanted to align, resize and equal space between contros.
> I can not find anything like MS Access align and size manual to use.
>
> Any way to make this tasks easier using Ms Excel?
>
>
> Your help is great appreciated,

Yes, Thnaks millions,


"Jim Thomlinson" wrote:

> Bring up the drawing toobar. If you click on the Draw button one of the
> options is Align or Distribute....
>
> I think that is what you want.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Souris" wrote:
>
> > I have a few command buttons on the spreadsheet to let user does somethign
> > different.
> >
> >
> > I wanted to align, resize and equal space between contros.
> > I can not find anything like MS Access align and size manual to use.
> >
> > Any way to make this tasks easier using Ms Excel?
> >
> >
> > Your help is great appreciated,

any pleace to resize fucntion to the same size?
Thanks again,

"Jim Thomlinson" wrote:

> Bring up the drawing toobar. If you click on the Draw button one of the
> options is Align or Distribute....
>
> I think that is what you want.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Souris" wrote:
>
> > I have a few command buttons on the spreadsheet to let user does somethign
> > different.
> >
> >
> > I wanted to align, resize and equal space between contros.
> > I can not find anything like MS Access align and size manual to use.
> >
> > Any way to make this tasks easier using Ms Excel?
> >
> >
> > Your help is great appreciated,

I have no idea what you are asking??? Please restate the question...
--
HTH...

Jim Thomlinson


"Souris" wrote:

> any pleace to resize fucntion to the same size?
> Thanks again,
>
> "Jim Thomlinson" wrote:
>
> > Bring up the drawing toobar. If you click on the Draw button one of the
> > options is Align or Distribute....
> >
> > I think that is what you want.
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Souris" wrote:
> >
> > > I have a few command buttons on the spreadsheet to let user does somethign
> > > different.
> > >
> > >
> > > I wanted to align, resize and equal space between contros.
> > > I can not find anything like MS Access align and size manual to use.
> > >
> > > Any way to make this tasks easier using Ms Excel?
> > >
> > >
> > > Your help is great appreciated,

The distribut space and align to align the controls.

I would like to have all my controls have same width and height.
In MS Access, I can shrink size to Shortest or grow to widest.

Does MS Excel have this function?

Thanks again,

"Jim Thomlinson" wrote:

> I have no idea what you are asking??? Please restate the question...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Souris" wrote:
>
> > any pleace to resize fucntion to the same size?
> > Thanks again,
> >
> > "Jim Thomlinson" wrote:
> >
> > > Bring up the drawing toobar. If you click on the Draw button one of the
> > > options is Align or Distribute....
> > >
> > > I think that is what you want.
> > > --
> > > HTH...
> > >
> > > Jim Thomlinson
> > >
> > >
> > > "Souris" wrote:
> > >
> > > > I have a few command buttons on the spreadsheet to let user does somethign
> > > > different.
> > > >
> > > >
> > > > I wanted to align, resize and equal space between contros.
> > > > I can not find anything like MS Access align and size manual to use.
> > > >
> > > > Any way to make this tasks easier using Ms Excel?
> > > >
> > > >
> > > > Your help is great appreciated,