create a micro for Auto Column Width and put on tool bar
 

I use Auto Column Width all the time and would love to do it as a macro and
just
click on a toolbar button everytime I want to use it.

create a micro for Auto Column Width and put on tool bar
 

Activesheet.Columns.AutoFit

Might be what you are describing.

--
Regards,
Tom Ogilvy

"Sunshine" wrote in message
...
I use Auto Column Width all the time and would love to do it as a macro
and
just
click on a toolbar button everytime I want to use it.