I'm making a NFL playoff bracket - So I've copy and pasted the helmets
of the teams over drop downs and am using ActiveSheet.Shapes("Picture
47").Visible = True then ActiveSheet.Shapes("Picture 48").Visible =
False to show the correct helmet.

But I'm having trobule keeping track of them. How can I change there
names?

e.g. Chargers - Chargers1 - Chargers2 - so on and so forth....


Thanks and Merry Christmas...

-Steve

You can change them manually by:
Selecting the picture
Type the new name in the namebox (to the left of the formulabar)
(remember to hit enter after typing the new name to complete the change)


(E-Mail Removed) wrote:
>
> I'm making a NFL playoff bracket - So I've copy and pasted the helmets
> of the teams over drop downs and am using ActiveSheet.Shapes("Picture
> 47").Visible = True then ActiveSheet.Shapes("Picture 48").Visible =
> False to show the correct helmet.
>
> But I'm having trobule keeping track of them. How can I change there
> names?
>
> e.g. Chargers - Chargers1 - Chargers2 - so on and so forth....
>
> Thanks and Merry Christmas...
>
> -Steve

--

Dave Peterson