VBA/Macro to delete particular sheets based on condition

[bakarken]

Hi all

I am preparing a spreadsheet which will have several sheets and a 'master' sheet. The user will first look at the master sheet and enter 'YES' or 'NO' as text in certain cells. I would like a macro where if the user types 'YES', CERTAIN sheets will be deleted.

For example;

If cell E30 (in 'MASTER' sheet) = 'YES', sheets 'Sheet A' and 'Sheet C' will automatically be deleted.
or if cell E40 (in 'MASTER' sheet) = 'YES', sheets 'Sheet B' and 'Sheet D' will automatically be deleted.

I am useless with macros, so if anyone with a response could tell me in WHAT sheet to paste the code and how to activate this, that would be great.

Much appreciated.

 

[bakarken]

That seems to have done the trick!

Thank you so much for the help I shall be eternally grateful

 

[Deasejm]

Gallen, I'm trying to do something similar and stumbled across your code. It works well, but I was hoping to make something a little more dynamic.
I want a macro that will delete specified sheets based on a specified category in a table of contents. Basically, on the main Instructions tab for the workbook, there is a table that lists every tab in the workbook, its purpose, and whether it is used at Interim or Year-End. On the Instructions tab is also a cell that asks what period it is (Interim / Year-End). I want the macro to delete any Year-End tab when the cell on the Instructions sheet is set to Interim. Is that possible?