Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer control the numbers assigned to grouped graphics? How? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Flintstone,
If it helps, you can this: ActiveSheet.Pictures.Insert("C:\My Pics\Sample.jpg").Select Selection.Name = "picOne" Then when looping through a collection/group, you can check the name property to see what you should do NickHK "Flintstone" wrote in message ... Anyone have any info or references on how group numbers are assigned to graphics groups in VBA? Can a Programmer control the numbers assigned to grouped graphics? How? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for that Nick, I'll give it a try.
I would still like to understand how the numbering system works and how it can be controlled so if there is anyone with references or who knows how it works I would still like to get the info. -----Original Message----- Flintstone, If it helps, you can this: ActiveSheet.Pictures.Insert("C:\My Pics\Sample.jpg").Select Selection.Name = "picOne" Then when looping through a collection/group, you can check the name property to see what you should do NickHK "Flintstone" wrote in message ... Anyone have any info or references on how group numbers are assigned to graphics groups in VBA? Can a Programmer control the numbers assigned to grouped graphics? How? . |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Flintstone,
Sorry, misunderstood you, I think. Each shape/group number is incremented by each time: "Line 1" "Rectangle 2" Group 2 above "Group 3" "Oval 4" "Rectangle 5" Group 2 above "Group 6" Group 2 groups "Group 7" Does that help ? NickHK "Flintstone" wrote in message ... Thanks for that Nick, I'll give it a try. I would still like to understand how the numbering system works and how it can be controlled so if there is anyone with references or who knows how it works I would still like to get the info. -----Original Message----- Flintstone, If it helps, you can this: ActiveSheet.Pictures.Insert("C:\My Pics\Sample.jpg").Select Selection.Name = "picOne" Then when looping through a collection/group, you can check the name property to see what you should do NickHK "Flintstone" wrote in message ... Anyone have any info or references on how group numbers are assigned to graphics groups in VBA? Can a Programmer control the numbers assigned to grouped graphics? How? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel graphics | New Users to Excel | |||
Excel Graphics | Charts and Charting in Excel | |||
Grouped Items won't Stay Grouped When Moving Object | Excel Discussion (Misc queries) | |||
Page numbering - grouped worksheets | Excel Discussion (Misc queries) | |||
Numbering of Grouped Rows | Excel Discussion (Misc queries) |