View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
franky franky is offline
external usenet poster
 
Posts: 8
Default Picture name is changin as worksheet is copied

Hi,

This newsgroup is great, I've been using it frequently. Thank you
My problem is that I'm using the code from
http://www.mcgimpsey.com/excel/lookuppics.html
to insert pictures in a worksheet according to a cell value, my chart is on
a separate sheet to lookup the picture number, however when I copy the sheet,
the pictures chage numbers, causing the wrong pictures to be called out.
Any idea what is happening, I tried copying to new sheets with the test file
that's on the McGimpsey site, and the picutes keep their corresponding number.

Thanks in advance