Back to Browse

How to delete multiple sheets in Excel automatically

11.4K views
Aug 30, 2018
4:03

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