Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Anpu Massri on Jan 31 In MS Office Category.

Delete all worksheets but the summary

Question Answered By: Varick Fischer on Jan 31

Dim wrksht As Worksheet
Application.DisplayAlerts = False
For Each wrksht In Worksheets
If wrksht.Name <> "Summary" Then wrksht.Delete
Next
Application.DisplayAlerts = True

This Question has 1 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Delete all worksheets but the summary Or get search suggestion and latest updates.

Related Topics:

Updating worksheets to my Summary in workbook
Need help coping images (gif pictures) from worksheet to worksheet
Need help coping images (gif pictures) from worksheet to worksheet
Excel data transfer automatically from master worksheet to other worksheets
Prevent user from delete a worksheet in using the shortcut menu of
Delete Worksheet
When trying to Delete a Worksheet - Error Pops UP
No action is occured when i click the delete link to delete the ite
Toggle images on a worksheet?
Problem with Length of the worksheet name
How to store user input in a worksheet?
List of objects on a worksheet within a workbook
move between worksheets
worksheet help please
Ghost Hand on my worksheet
Best way to distribute Excel worksheets
Protecting worksheet names
Run-Time Error '1004' (Copying worksheets)
inserting custom template into worksheet
How to insert some worksheets to a closed workbook

Tagged:delete all worksheets but the summary

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us