ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Picture Problems (https://www.excelbanter.com/excel-programming/395733-re-picture-problems.html)

joel

Picture Problems
 
I always have problems with getting picture names as long as other shapes.
Try using this code to help you get the names of the obbjecs

Sub test()
For Each myshape In Worksheets("Sheet1").Shapes
MsgBox (myshape.Name)
Next myshape

End Sub

Then you'll know the names of the pictures.

"Confused at Work" wrote:

Just wondering I have multiple worksheets and on the main worksheet screen is
my invoice page, all the rest is programming related. Now depeneding on the
customer I want them to be able to click on a number and then their logo come
onto the page at the bottom of the screen. I have the logos set on a
different page, but just can convert them over to the main page. I think it
has something to do with the cells, I cant make my picture into one cell, its
always picture #1 or picture #2. Any suggestions or help with this one?



All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com