VBA Script to save&close excel worksheet after a single cell changes via conditonal format

I need a VBA script to save and close the worksheet after a cell changes colour due to conditional formatting (ive already done).

Basically I have a progress bar that fills up more and more everytime a form tick box is ticked.. e.g. 4 tick boxes. once they click 2 its 50% full.

I need the script/macro to recognise when the final cell is green because it is 100%complete - save and close the work book.


any ideas?

thanks.

why don't you just run a simple VBA code to check for the 04 tick boxes under the Worksheet_Change event - if all of em are checked, then just save & close the workbook using

Please Login or Register  to view this content.

if the conditional formatting depends only and only on the tickboxes that this should work fine.

I have MINIMUM experience with VBA. So to be honest, at this exact moment I do not know how to do that. I am VERY rusty lol.

appreciate the reply.