| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba and orgchart shapes
you aren't... thanks!
Luc "Jim Rech" wrote in message ... Selection.Interior.Color = 12632256 or am I missing something? -- Jim Rech Excel MVP "Luc Benninger" <lb (at) zignet.ch wrote in message ... | no, it don't. (well, or am i missing something??) | i just want vba to change the fill color of the currently selected shape(s) | in a diagram. | in word and powerpoint the selection object has a childshaperange property | for doing this. but excel...?? | Luc | | "Jim Rech" wrote in message | ... | Does Selection.Name and/or Typename(Selection) help? | | -- | Jim Rech | Excel MVP | "Luc Benninger" <lb (at) zignet.ch wrote in message | ... | | how can I detect with vba what shapes in an organization chart diagram | are | | currently selected? if text in such a shape is selected I can get the | shape | | reference with the parent property. but what can I do if one or more | shapes | | are selected? | | using excel xp/2003. | | thanks a lot, Luc | | | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
| Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
| Excel- orgchart and databases | Charts and Charting in Excel | |||
| When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
| excel macro to update visio orgchart | Excel Discussion (Misc queries) | |||
Hybrid Mode
