RoyUK,

That works great but what how would I need to amend the code if I wanted to generate a message box, if the box is then unchecked, asking the user whether they want the sheet deleted or not. If the user selects No, then the value of the checkbox needs to be set to True again.

Thanks