Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002: How to insert an Auto Fit Width button at the tool bar Mr. Low Excel Discussion (Misc queries) 2 July 4th 09 10:19 AM
how do I create multiple column width in the same column in excel Vish Excel Discussion (Misc queries) 9 November 3rd 06 11:49 PM
auto fit column width and row height kb Excel Discussion (Misc queries) 0 May 22nd 06 07:54 PM
Auto Adjust the Width of a Column reddog9069[_4_] Excel Programming 1 June 21st 05 05:10 PM
Is it possible to create one column with two different width? Dave H... Excel Worksheet Functions 0 February 21st 05 05:45 PM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"