Step by step tutorial on how to delete multiple sheets in excel with a button or when closing the workbook.
If you wish to manually delete multiple sheets, hold down shift key and mark the desired sheets for deletion.
You can get the code seen in the video from here: https://pastebin.com/9jNwL90D
Visual Basic (VBA) is being used for this example in order for the sheets to be automatically deleted upon closing the workbook.
In other words, this will work for Excel 2007, 2010, 2013, and Excel 2016 as seen in the video.
Download
0 formats
No download links available.
How to delete multiple sheets in Excel automatically | NatokHD