Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture #s Assigned to Objects
When I insert a graphic object, it is automatically assigned a number i.e.
"Picture 123". <Msgbox Application.Caller.Name displays this auto assigned number. Is there anyway to set or change the number assigned to such objects? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture #s Assigned to Objects
The basic code to rename a picture/shape is:
ActiveSheet.Shapes("Picture 123").Name = "MyNewName" If the code you used in your message box is giving you the actual picture name, then store the name in a memory variable (ie: rather than Msgbox use MyShapeName = ). Then your line of code would be: ActiveSheet.Shapes(MyShapeName).Name = "MyNewName" Replace "MyNewName" with whatever naming convention you wish to use. -- Thx MSweetG222 "VicWestVan" wrote: When I insert a graphic object, it is automatically assigned a number i.e. "Picture 123". <Msgbox Application.Caller.Name displays this auto assigned number. Is there anyway to set or change the number assigned to such objects? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture #s Assigned to Objects
Select the object
type the new name in the Namebox (to the left of the formula bar) make sure you hit enter And you can give the picture a nicer name--either based on what it is or based on where it is??? Pict_A3 (if it's in A3) Picture_Of_My_Family VicWestVan wrote: When I insert a graphic object, it is automatically assigned a number i.e. "Picture 123". <Msgbox Application.Caller.Name displays this auto assigned number. Is there anyway to set or change the number assigned to such objects? -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture #s Assigned to Objects
Thx Dave
"Dave Peterson" wrote: Select the object type the new name in the Namebox (to the left of the formula bar) make sure you hit enter And you can give the picture a nicer name--either based on what it is or based on where it is??? Pict_A3 (if it's in A3) Picture_Of_My_Family VicWestVan wrote: When I insert a graphic object, it is automatically assigned a number i.e. "Picture 123". <Msgbox Application.Caller.Name displays this auto assigned number. Is there anyway to set or change the number assigned to such objects? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Picture objects and text boxes change position | Charts and Charting in Excel | |||
Delete Picture Objects | Excel Programming | |||
find picture objects | Excel Programming | |||
Bitmap data of Image controls & Picture objects... | Excel Programming | |||
Picture with Macrto Assigned causes problem | Excel Programming |