View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish
 
Posts: n/a
Default Can I select and Group Autoshapes in Excel 97 ?

To select all the objects on the sheet --
Choose EditGo To, click Special
Select Objects, click OK

Then, press the Delete key, to delete the selected objects.

Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:

Choose ToolsCustomize
Select the Commands tab
Select the Drawing Category
Drag the 'Select Multiple Objects' tool onto one of your toolbars
Click Close

Then, click the Select Multiple Objects button, and select any or all
objects on the worksheet.
Press the Delete key, to delete the selected objects.


diglas1 via OfficeKB.com wrote:
Don, thanks for that, it works a treat, but what I'd prefer to do is to
select the lot so I can delete, or save the group elsewhere.



diglas1 wrote:

David , I'm just off to bed and saw your response, so many thanks, haven't
read your site yet but looks fantastic...will dive in tomorrow.


see Shapes
http://www.mvps.org/dmcritchie/excel/shapes.htm


[quoted text clipped - 9 lines]

Any suggestions welcome
Thanks in anticipation.




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html