VBA to Delete all Sheets except Specific Sheet - Excel VBA Tutorial

This VBA Tutorial explains how to delete all worksheets except specific sheets using vba code. In Excel VBA, we can automate to delete multiple sheets using VBA Programming.

[@rahul279gadakar3]

Sir, I am your fan U solved my biggest prob in excel

[@nikhilverma8778]

Thank You for your Support by this Video This Video Very Useful because after watching video I solved my query

[@ExcelDestination]

Great 👍

[@MohAboAbdo]

Thank you very much for this great video.

[@ExcelDestination]

appreciate!

[@rodrigohonorio4978]

awesome, thanks

[@MotiDeviMithila]

How can we run this code automatically when we close the workbook

[@sudeshsrivastava1435]

vba code to remove duplicate values in multiple sheets in single excel workbook?

[@vipulprajapati2797]

Hello Sir, Agar muje ek specific column every sheets me se delete karni ho to is it possible? Suppose meri 100 Sheets he usme se muje C column delete karna he simultenously to is it possible?

[@lilycheong3832]

Good program...

[@mustafa_ozer]

Hi. Thanks for the help. I'd appreciate if you could help me with this: I have a bunch of excel files. I want to combine these files, rename the first sheet same as the file name, delete the subsequent 2 sheets opened automatically (sheet 2, and 3). Is it possible to do this on VBA? If yes can you help with the code? Thanks.

[@nguyenchung4795]

Can you code for deleting all sheets except for 2 specific sheets? Thanks.

[@ExcelDestination]

You can just add one more condition and same code can be used like. If worksheets(I).name "abc" and worksheets(i).name "xyx". something like this.

[@nguyenchung4795]

Thanks a lot. It’s very useful.

[@nguyenchung4795]

@@ExcelDestination Thanks

[@yogeshsawant4527]

Sir can we use the same for 5 sheets. I mean I want to keep 5 sheets and delete rest of sheets

[@AkshayKumar-wy5ks]

Below you mentioned it is not working if we want to keep more than 1 sheet. Could you please write a code.that would help.

[@songhonnhientrongthegioiao2291]

It would be great if you include the practice file too

[@ExcelDestination]

you can send me email at [e-mail] , I will send you the file. This code is very short. you can pause and note down. This will enable you to practice also.

[@sridharkrishnappanavanerth3388]

Sir i need your urgent help. I am working on a inventory project which is macro enabled with 11 worksheets. I have to save as a specific sheet that is invoice template to another workbook as excel file(.xlsx) . after save as the workbook should contain only Invoice Template worksheet. And after all the process my Inventory Template from original Inventory project workbook should be open.

[@ExcelDestination]

for any urgent project, you can write to [e-mail]

[@barbhayar]

Ye to sahi he par muje specific time or days ke bad automatic delit kar na he to kya jare

[@Lone.wolf004]

First, Thank you sir for this. But I have a question. What if there are two specific sheet that I dont want to delete. How can I do that. Thank you. more power!

[@user-jp3kv8os4p]

i also want this answer, sir please reply

[@rajnishgraphicsstudio2756]

Sir aise hi multi sheets ke sheet nhi row delete ho pleases