Thread: How do I expand more than one comment box at same time?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I expand more than one comment box at same time?
See Debra Dalgleish's site for code.

Note two sets of code...one for worksheet.....one for a range.

http://www.contextures.on.ca/xlcomments03.html#Resize


Gord Dibben MS Excel MVP

On Tue, 22 Aug 2006 13:12:02 -0700, carol
wrote:

saved a copy of a data base and all the comment boxes reduced in size so
unreadable. Need to expand all comment boxes at one time or find out why
saving a file with new name changes size of orginal comment box

Reply With QuoteReply With Quote