LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Question macro for reseting size of comment with no text

Hi! I think I posted my first thread in the wrong section.. I'm trying to create a macro which would resize a comment size to the size of the picture I used in the fill. (format comment colors and lines color fill effects picture) There is NO text in it so I can't resize based on that. All the comments are reshaped when I added/deleted a row/column. :( I have a lot of comments with different sized pictures and I don't want to go through each one to resize it. Please help! Thanks in advance! :)
 
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
HELP! macro for reseting size of comment with no text goos3y New Users to Excel 0 November 27th 12 02:07 AM
Comment Box Size = 125% Fill Picture Size Jason W Excel Programming 1 October 27th 09 03:28 PM
how do i reformat text size in all comment boxs to a default size bwnsgr96 Excel Worksheet Functions 1 August 20th 08 09:35 PM
Adjusting comment box size by Macro yshridhar Excel Discussion (Misc queries) 2 February 5th 08 09:19 AM
Setting size of comment under macro control? Don Wiss Excel Programming 2 November 19th 05 03:49 AM


All times are GMT +1. The time now is 12:32 AM.

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

About Us

"It's about Microsoft Excel"