Hi

I have about 5 command buttons on my spreadsheet.

Is it possible to align these to the bottom and to space them evenly (other
than manually and by eyeing)...if yes.. how..

Thanks in advance !

Kimberly

-----Original Message-----
Hi

I have about 5 command buttons on my spreadsheet.

Is it possible to align these to the bottom and to space
them evenly (other
than manually and by eyeing)...if yes.. how..

Thanks in advance !

Kimberly


Hi Kimberly,

Unfortunately I have found no way to do this. What I do is
use the grid pattern on the spreadsheet to do my aligning.

Hope this helps.
.

Hi Kimberly

Excel doesn't have a "snap to grid" tool like a programming suite does (at least I never
found it). So you'd have to use macro code or the eye for a lineup. Which isn't that bad
if you zoom the sheet (View menu, choose 200 or more).

Beware of "Bottom" though. Wherever that might be depends on window state, zoom ratio,
screen resolution, all user variables and rarely identical.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"KimberlyC" wrote in message
...
Hi

I have about 5 command buttons on my spreadsheet.

Is it possible to align these to the bottom and to space them evenly (other
than manually and by eyeing)...if yes.. how..

Thanks in advance !

Kimberly

Use the Alt key to drag the button to the top LH crn of a cells for
alignment

KimberlyC wrote in message
...
Hi

I have about 5 command buttons on my spreadsheet.

Is it possible to align these to the bottom and to space them evenly
(other
than manually and by eyeing)...if yes.. how..

Thanks in advance !

Kimberly