Hi.
I have a situation where I have already selected a picture that I have inserted into my Excel worksheet, locked to a cell.
Then I need a macro to do the following:
1. If it is landscape (ie the height is greater than the width), rotate 90 degrees.
2. Copy the Alternative text into the cell in which the object resides.
3. Use the alternative text as a hyperlink on the picture.
Thank you.
I have a situation where I have already selected a picture that I have inserted into my Excel worksheet, locked to a cell.
Then I need a macro to do the following:
1. If it is landscape (ie the height is greater than the width), rotate 90 degrees.
2. Copy the Alternative text into the cell in which the object resides.
3. Use the alternative text as a hyperlink on the picture.
Thank you.