Delete sheet by condition

[Birnen]

good morning everyone.

I've searched the forum for a macro to delete sheet with a condition.
but this to me to be difficult to find one that can change.


what I intend to do is a macro to delete a certain and particular sheet is the same in one cell does not contain a certain value and determined.


can help me.

best regards

[oeldere]

Probably I can't help you enough.

But your description to determine the condition of deleting the sheet is not clear to me.

You mean a cell on the sheet

or

you mean a sheetname

or

if a cell in a cell in a particular sheet is the same a a cell in another sheet.

More info is needed.

[Birnen]

I apologize for my information to be little short.


I intend in reality, for example.


if in cell A1 does not contain the word 'hello', then I want the macro to delete this entire sheet.

best regards

Probably I can't help you enough.

But your description to determine the condition of deleting the sheet is not clear to me.

You mean a cell on the sheet

or

you mean a sheetname

or

if a cell in a cell in a particular sheet is the same a a cell in another sheet.

More info is needed.

[HaHoBe]

Hi, Birnen,

donīt quote full posts please.

Please Login or Register  to view this content.

Ciao,
Holger

[Birnen]

this code is working, but not quite it.
the word Hello is already in cell A1, and if someone delete the contents of cell A1. the macro should run automatically ...

[HaHoBe]

Hi, Birnen,

maybe this is what you are looking for (it will be triggered on any chage or edit in the range A1 on any worksheet). Code goes into ThisWorkbook:

Please Login or Register  to view this content.

Ciao,
Holger

[Birnen]

Thank you very much

This working perfectly


Best regards

A special thank you to Hahobe.