View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
B J W B J W is offline
external usenet poster
 
Posts: 4
Default manipulating displayed pictures: can I rename the various Shapes to make coding easier.

I have a spreadsheet, used as a data collection form, which incidentally
displays a corporate division logo.

I would like the logo displayed to be dependent on a particular value
entered, a value identifying the corporate division.

I can record a macro, which changes which logo is in front, and in the
process discovered the names of particular logo graphics (e.g.
activesheet.shape("picture 10").select)

For each logo graphic, I have recorded code that puts that graphic on top of
a blank gif, which in turn covers all the other graphics. I have a Select
Case statement, which determines, on the basis of entered data, which code
runs, and therefore which logo graphic shows on the page.

I was wondering if there is a way to rename "picture 10" to something more
meaningful. It sure would make the code easier to read.

Is it possible to give graphics, names, and to manipulate those graphics, by
name?

Is there a better way than just having all possible graphics in place, and
manipulating the layering to determine which one shows?