I've placed a command button on my Excel worksheet.
I want to be able to clear the contents (set them to zero) of cells C3 through C10, D3 through D10 and E3 through E10 by clicking on the button.
Each of the cells is formatted as "Accounting".
However, I want to give the user the chance to opt out of clearing the contents via a VBYesNo message.
Something like "Are you sure you want to clear the contents of this worksheet?"
If the user selects Yes, I not only want the cells' contents to be cleared but for the worksheet to be saved as well.