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
|