Delete all sheets that meets my critera without prompt

vlacombe

New Member
Joined
Oct 4, 2019
Messages
31
I'm looking for a script to delete any sheets that meets the following critera and without promtp:
If sheets contains the text: "PrixMax" "6po" "Quote" Then deleted them

Sheet name can be "PrixMax-250", "6po-Viny", "Quote-101018"
Along with those sheets, my workbook contains a "Master" sheets and "templates" which will remain

Thank you
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
With pleasure, although here we continue to learn every day.

True that,

I did some VB back in school about 20 years ago, but I never pursued that line of work at all.
It's really nice to see such a great community around here

Feels good to get back into it though... and now that I could rly need some php and MySQL skills right now, I really want to dive into it :)

See you around
 
Upvote 0
Would it be much complicated to have seperated script for

1. Print sheets seperately without prompt to the default printer: only the sheets mentionned above (If sheets contains the text: "PrixMax" "6po" "Quote" Then print them)
2. Create a PDF per sheet
(If sheet contains the text: "PrixMax" "6po" "Quote" Then create a PDF for each) without prompt (like using the microsoft print to PDF "printer" even though it's not the default printer, and send the file(s) to a specific path written in the script... like the desktop or a folder on the desktop.

Or should I start another thread ?
 
Last edited:
Upvote 0
Please start a new thread, as it's a totally different question.
Thanks
 
Upvote 0

Forum statistics

Threads
1,223,704
Messages
6,173,984
Members
452,540
Latest member
haasro02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top