A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

possible to default?: Format Comment > Alignment > Automatic Size



 
 
Thread Tools Display Modes
  #1  
Old June 24th, 2004, 05:17 PM
external usenet poster
 
Posts: n/a
Default possible to default?: Format Comment > Alignment > Automatic Size

Rather than selecting the "Automatic Size" for each cell
comment ONE AT A TIME, is it possible to set your options
so that all cell comments start out with the automatic
size feature enabled?
Thank you.
  #2  
Old June 24th, 2004, 11:32 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default possible to default?: Format Comment > Alignment > Automatic Size

The change comments at one time with a macro
http://www.mvps.org/dmcritchie/excel...ent.htm#resize

To catch comments and resize them when the workbook is
opened see Stephen Bullen's reply in
http://groups.google.com/groups?th=4e1723a41570510d
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message ...
Rather than selecting the "Automatic Size" for each cell
comment ONE AT A TIME, is it possible to set your options
so that all cell comments start out with the automatic
size feature enabled?
Thank you.



  #3  
Old June 25th, 2004, 01:05 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default possible to default?: Format Comment > Alignment > Automatic Size

How about resizing them when you're done via a macro?

http://www.contextures.com/xlcomments03.html#Resize
(From Debra Dalgeish's site)

wrote:

Rather than selecting the "Automatic Size" for each cell
comment ONE AT A TIME, is it possible to set your options
so that all cell comments start out with the automatic
size feature enabled?
Thank you.


--

Dave Peterson

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the default font size of comments? David Setting up and Configuration 3 April 13th, 2004 06:33 PM
Default File Location Derek Ruesch Setting up and Configuration 6 January 30th, 2004 04:03 AM
How to change Excel comment default font size? (for Office 2000) Jason Setting up and Configuration 1 December 24th, 2003 03:35 PM
Changing default number format in worksheets John deChadenedes Worksheet Functions 0 October 9th, 2003 05:52 PM
default (start-up) window size fw Setting up and Configuration 0 October 2nd, 2003 03:31 AM


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


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