Delete Sheet Based on Master Sheet Criteria

[Evgeny]

Hi everyone, Im new to VBA and Macros.

I need your help, as my boss asked if its possible to automaticly delete sheet from from workbook based on information from master sheet.
I have a workbook with 50 sheets in it and master sheet with names of those sheet. So what he wants me to do is when I delete one of those names on the cover sheet the relevant sheet will be automaticly deleted from the workbook. Is it possible?

I hope it makes sence.

Please help

Thank you

Evgeny

[antoka05]

You can try with this macro:

Please Login or Register  to view this content.

Regards,
Antonio

[Evgeny]

Thank you, but didnt seem to work. How do you relate those sheet to master sheet?

Cheers

[antoka05]

Macro seeks the name of several sheets in cells of sheet named 'master' and if not found remove sheet... how can I help you better?

Regards,
Antonio

[Evgeny]

Thank you for fast reply. Sorry, VBA and Macros get me really frustrated, since i am really new to it Could you give me an example of how it works or shall post the Excel workbook for you to look over?

I have been trying to find an answer for ages, but had no luck. In the end i told my boss there is no way to do, but with your kind help i can possible impress him

Kind Regards,

Evgeny

[antoka05]

I attached workbook. To apply macro you can click right mouse on sheet name and select view code.

Regards,
Antonio

[Evgeny]

Works great, thanks a lot !!!

[Evgeny]

Many thanks again, is there a return function to undo delete?

Regards,

Evgeny