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

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

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

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

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

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