Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2,718

Comments autofit

Perhaps...

Sub aa()
Dim Cmt As Comment
For Each Cmt In Sheet1.Comments
Cmt.Shape.Width = 200
Next
End Sub

--
Jim Rech
Excel MVP

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 2000 how to format the comments font all comments	Delquestion	Excel Discussion (Misc queries)	1	October 8th 09 02:19 PM
Autofit (Columns.EntireColumn.AutoFit) does not work	Michiel via OfficeKB.com	Excel Discussion (Misc queries)	3	February 10th 09 05:29 PM
in excel useing comments how do you add clip art to comments?	dhouse	New Users to Excel	2	July 18th 07 08:14 AM
autofit does not autofit	rreneerob	Excel Discussion (Misc queries)	1	October 17th 05 05:55 PM
row autofit	Robin Hammond	Excel Programming	0	September 6th 03 02:33 AM

All times are GMT +1. The time now is 03:07 PM.

About Us

"It's about Microsoft Excel"