Carl A
09-17-2008, 03:46 PM
I think the answer to my question is NO but I'm open to suggestions!
I have a simple routine that inserts a picture into a comment by using FileDialog.
This routine works very well however, is there any way to auto size the comments to the pictures dimensions i.e. height and width?
I have used Debra Dalgleish example on http://www.contextures.com/xlcomments03.html#Picture Insert Selected Picture into Comment which works well, however I would like to simplify the process by not having to have the picture loaded into the spreadsheet.
I have a simple routine that inserts a picture into a comment by using FileDialog.
This routine works very well however, is there any way to auto size the comments to the pictures dimensions i.e. height and width?
I have used Debra Dalgleish example on http://www.contextures.com/xlcomments03.html#Picture Insert Selected Picture into Comment which works well, however I would like to simplify the process by not having to have the picture loaded into the spreadsheet.