Hello everyone
I have an Excel (2016) that consists of 5 work sheets. All are protected with specific cells on each sheet being unprotected. I would like to clear all the data in the unprotected cells in 3 of the 5 worksheets proferably by clicking on a CommandButton. I would also like the safety net of an "Are you sure Y/N" when this button is pressed. There are many solutions on the net to clearing all the data in all the worksheets but I am struggling to get the code to work when specifying the sheets. Thanks for your help
I have an Excel (2016) that consists of 5 work sheets. All are protected with specific cells on each sheet being unprotected. I would like to clear all the data in the unprotected cells in 3 of the 5 worksheets proferably by clicking on a CommandButton. I would also like the safety net of an "Are you sure Y/N" when this button is pressed. There are many solutions on the net to clearing all the data in all the worksheets but I am struggling to get the code to work when specifying the sheets. Thanks for your help
