View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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?