I use the comment function in making spreadsheets for collectibles to add photographs and various other key information. In regards to the photographs, is their a way to preset the image size to be the same for each cell without having to size the photo for each cell in each row or can it be done by formatting each column to cover each individual cell in a row? Hopefully, I have made myself clear as to my needs, if not I apologize.
Thank you for your assistance.
Jim
try this method...
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thanks for your reply kev. As I said, I am NOT any form of an expert with excel and have not entered commands before. Can you guide me thru the process of entering this command? Again, I thank you for your time and in no way wish to abuse it.
Thank you,
Jim
easiest way:
{ALT}{F11} (takes you to VBA window) \ Insert \ Module \ Paste the code in that window
{ALT}{F11} (takes you to back to Excel)
{ALT}{F8} (brings up macro list)
Select ResizeImagesInComments and run
You will need to save your workbook as macro-enabled
Last edited by kev_; 06-23-2018 at 10:10 AM.
I tried that, kev, but I get an out of memory error 7 and I tried reloading 2003 but to no avail. So I'll have to repair this first.
Again, I thank you for your prompt reply.
Jim
Try in a new file with only 3 cells with comments containing images
- that will at least prove the code works with 2003 (I tested with 2016)
Let me know and we will take it from there.
How many cell comments contain images?
None, new worksheet I was trying it on.
I have no idea why it is not working, but guess that something has changed since Excel 2003. Let's break down the code to see what happens.
In a new workbook
1. In Sheet1 insert a shape in a comment in cells A1 to A5 (5 cells all with comments)
2. Put this code in a module as before
3. Run each macro as before and let me know what the 2 message boxes returnPlease Login or Register to view this content.
- CountComments should return 5
- I am guessing that width and height may not be returned
4. How do you insert a shape into a comment in Excel 2003?
- brief list of options\actions taken
I have attached workbook containing above 3 macros in format that is compatible with Excel2003
Download it and see if you can run the macros
It says VBE6EXT.OLB could not be loaded and when you enter ok, it says out of memory
I ran Office 2003 repair editor and it seemed to repair it at first, but when I did as you instructed(A1,A2,A3,A4,A5 with pic in comments) and hit the Alt/F11 key here's what I got.
2018-06-23_19-21-14.jpg
kev,
Thank you so much, it worked fine this time, don't know why but it did and its exactly what I need. Again, I truly thank you.
Jim
BTW, the first easiest way was what worked. I just had some malfunction that running Microsoft Repair Editor fixed. Then all was well using the easiest way. Great. Already used it on a 180 picture worksheet in comments over A,B,C,D columns and 1-62 rows. They are all the same. For some reason I had to make the width about 20% larger than heighth to get them equal when viewing them via mouseover. Hopefully, I will not aggravate you again.
Jim
Glad you found the source of the problem.
Please click Thread Tools @top of thread and mark thread SOLVED
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks