#1   Report Post  
Eddie
 
Posts: n/a
Default Comment window size

It is possible to change the default size of the comment
window?
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

You cannot change the size of the default comment but you can use a macro to
create a comment and change its size:

Sub NewComment()
On Error Resume Next
With ActiveCell.AddComment.Shape
.Width = 100
.Height = 60
.Visible = msoTrue
.Select
End With
End Sub


--
Jim Rech
Excel MVP
"Eddie" wrote in message
...
| It is possible to change the default size of the comment
| window?


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
Customize page size puzzled Setting up and Configuration of Excel 0 February 18th 05 05:41 AM
I can't adjust the window size of an active workbook. Julie Excel Discussion (Misc queries) 1 January 26th 05 05:19 PM
Alternative window size? Hans Näslund Excel Discussion (Misc queries) 1 January 17th 05 11:13 PM
Alternative window size? Hans Näslund Excel Worksheet Functions 0 January 17th 05 02:26 PM
changing comment indicator size or shape Mrocka Excel Worksheet Functions 1 December 13th 04 02:53 PM


All times are GMT +1. The time now is 09:03 AM.

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"