aligning control buttons on a worksheet

K

KimberlyC

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
 
G

G.Clark

-----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
Click to expand...
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.
 
H

Harald Staff

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.
 
Top