I have a macro file with 5 sheets and I would like to add a VBA command button into the same file to clean all workbook contents with a single click. Does anyone know how to do it by using VBA on excel 2010?
Macro for cleaning all sheets in a workbook (VBA – Excel 2010)
macrosmicrosoft-excel-2010vba
Best Answer
Cleraing all sheets in a workbook:
Edit1: see source
Deleting them instead of cleaning: