View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
diglas1 via OfficeKB.com
 
Posts: n/a
Default Can I select and Group Autoshapes in Excel 97 ?

Debra,
This is great, it actually solves the problem, would never have found it
myself. Thanks a lot.

Debra Dalgleish wrote:
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.

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.

[quoted text clipped - 9 lines]
Any suggestions welcome
Thanks in anticipation.



--
Message posted via http://www.officekb.com