When cell = 0; Save and Close.

[saudi_red_neck]

Hello friends, Hope all is well!

Can you please help me with the attachment here.
If and once the cell value of M5 of sheet DB becomes zero can the Workbook Save and close all the current progress.

Thank you so much in advance!

[PCI]

See how next macro could help, have look in the file attached

Please Login or Register  to view this content.

[saudi_red_neck]

This is great thank you. But can you please help me adjusting the code, so that when workbook opens the code runs automatically?
I tried to make the adjustments (attachment included) but I am getting Run Time Error 13 – Type Mismatch.

Thank you so much in advance!

[PCI]

when workbook opens the code runs automatically?

Yes it is like that now see macro Workbook_Open()
But the format of the cells is Text: See file attached