Excel 2002: How to insert an Auto Fit Width button at the tool bar

[Mr. Low]

Hi,

I try to customise my tool basr with the above button, but could not find
this option under the customisez selection Format > Column Width > Auto Fit.

Can anybody help me on this ?

Thanks

Low

 

[FSt1]

hi
there isn't a built in icon for auto fit. there is one of manual fit. auto
fit is usually done you placing the mouse pointer on the column header row on
the right line of the column you want to fit. the mouse pointer will change
to a vertical line with arrows on both sides pointing out. double click to
auto fit.
but if you want an icon, you can attach this macro to your button.
just select the column you want to autofit then click the button.
sub autofitcolumn()
selection.entirecolumn.autofit
end sub
regards
FSt1

 

[Mr. Low]

Hi,

Thanks for your reply.

Low
--
A36B58K641

hi
there isn't a built in icon for auto fit. there is one of manual fit. auto
fit is usually done you placing the mouse pointer on the column header row on
the right line of the column you want to fit. the mouse pointer will change
to a vertical line with arrows on both sides pointing out. double click to
auto fit.
but if you want an icon, you can attach this macro to your button.
just select the column you want to autofit then click the button.
sub autofitcolumn()
selection.entirecolumn.autofit
end sub
regards
FSt1