aligining buttons
I have macro buttons which i want to perfectly aliggn between AB+AC
I cant find anything on the format control so i am wondering is there a little sub i could run to keep them exactly so many CM from edge of WS, there all the same size (format control) but not exactly in line with each other. There stacked on top of each other
Thanks
Seamus
I cant find anything on the format control so i am wondering is there a little sub i could run to keep them exactly so many CM from edge of WS, there all the same size (format control) but not exactly in line with each other. There stacked on top of each other
Thanks
Seamus
jppinto
Add the Align button menu on the Drawing Tools tab to the Quick Access Toolbar.
if you right click each button in turn, you are able to select Properties.
Within the list of properties is a LEFT setting
You can set each one as the same (it also has a width property too).
Within the list of properties is a LEFT setting
You can set each one as the same (it also has a width property too).
Please take a look at the attached image...
Capturar.JPG
Capturar.JPG
Also take a look at this article from Microsoft:
http://office.microsoft.com/en-us/excel-help/group-copy-move-or-align-controls-on-a-worksheet-HP010236688.aspx#BMalign_and_distribute_controls
jppinto
http://office.microsoft.com/en-us/excel-help/group-copy-move-or-align-controls-on-a-worksheet-HP010236688.aspx#BMalign_and_distribute_controls
jppinto
Well I'll be!
ASKER
I cant find this guys! Im 2003 and a little dozy!
Sorry...you didn't mentioned the Excel version! This is for Excel 2007/2010!
ASKER
Its telling me to select multiple objects but i cant seem to select multiple buttons? im using control and select but to no avail?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect!!