Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select All Shapes
I have put a number of Shapes on my worksheet using VBA. Now I need to
select all the shapes on the worksheet. TIA, James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select All Shapes
activesheet.shapes.selectall
??? Zone wrote: I have put a number of Shapes on my worksheet using VBA. Now I need to select all the shapes on the worksheet. TIA, James -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select All Shapes
Dave, you are the man.
Now I want to group all these shapes into one shape, draw some more stuff, then send all the grouped shapes to the back. Something like activesheet.shapes.selectall 'group all the selected sheets together 'draw some more shapes 'send all the grouped shapes to the back Any suggestions greatly appreciated. Willing to grovel. James Dave Peterson wrote: activesheet.shapes.selectall ??? Zone wrote: I have put a number of Shapes on my worksheet using VBA. Now I need to select all the shapes on the worksheet. TIA, James -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select All Shapes
Pardon, Dave. Of course, I meant
Something like activesheet.shapes.selectall 'group all the selected SHAPES together 'draw some more shapes 'send all the grouped shapes to the back Zone wrote: Dave, you are the man. Now I want to group all these shapes into one shape, draw some more stuff, then send all the grouped shapes to the back. Something like activesheet.shapes.selectall 'group all the selected sheets together 'draw some more shapes 'send all the grouped shapes to the back Any suggestions greatly appreciated. Willing to grovel. James Dave Peterson wrote: activesheet.shapes.selectall ??? Zone wrote: I have put a number of Shapes on my worksheet using VBA. Now I need to select all the shapes on the worksheet. TIA, James -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select All Shapes
I'd suggest recording a macro when you did it manually to see the code.
Zone wrote: Pardon, Dave. Of course, I meant Something like activesheet.shapes.selectall 'group all the selected SHAPES together 'draw some more shapes 'send all the grouped shapes to the back Zone wrote: Dave, you are the man. Now I want to group all these shapes into one shape, draw some more stuff, then send all the grouped shapes to the back. Something like activesheet.shapes.selectall 'group all the selected sheets together 'draw some more shapes 'send all the grouped shapes to the back Any suggestions greatly appreciated. Willing to grovel. James Dave Peterson wrote: activesheet.shapes.selectall ??? Zone wrote: I have put a number of Shapes on my worksheet using VBA. Now I need to select all the shapes on the worksheet. TIA, James -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select All Shapes
Thank you. James
Dave Peterson wrote: I'd suggest recording a macro when you did it manually to see the code. Zone wrote: Pardon, Dave. Of course, I meant Something like activesheet.shapes.selectall 'group all the selected SHAPES together 'draw some more shapes 'send all the grouped shapes to the back Zone wrote: Dave, you are the man. Now I want to group all these shapes into one shape, draw some more stuff, then send all the grouped shapes to the back. Something like activesheet.shapes.selectall 'group all the selected sheets together 'draw some more shapes 'send all the grouped shapes to the back Any suggestions greatly appreciated. Willing to grovel. James Dave Peterson wrote: activesheet.shapes.selectall ??? Zone wrote: I have put a number of Shapes on my worksheet using VBA. Now I need to select all the shapes on the worksheet. TIA, James -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Select Multiple Shapes | Excel Discussion (Misc queries) | |||
Select and Move Cursor Shapes | New Users to Excel | |||
how to select ALL named shapes in range | Excel Programming | |||
Select multiple Shapes | Excel Programming | |||
Using Arrays to select Shapes | Excel Programming |