Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect a number to a picture bank and import that picture to exce Dennis Hedo Excel Discussion (Misc queries) 1 March 22nd 10 02:17 PM
Picture problems in custom header DDawson Excel Discussion (Misc queries) 0 March 11th 08 12:10 PM
Picture Problems Confused at Work Excel Programming 3 August 17th 07 02:06 AM
Picture Problems Joel Excel Programming 0 August 17th 07 01:43 AM
insert a picture in to a comment but picture not save on hard disk Pablo Excel Discussion (Misc queries) 0 February 21st 07 03:48 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"