Thread: create a micro for Auto Column Width and put on tool bar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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.


Reply With QuoteReply With Quote