Using Access 2003 VBA Scripting to delete a worksheet tab in Excel workbook
Posted on 2011-04-28
This is a follow up question to one I asked earlier this morning about creating multi-tabbed Excel spreadsheets from an Access VBA Script. I now have a need to systematically delete tabs in a workbook. I was able to determine from the help I got earlier that I can use the command:
to delete a specific tab. However, if there is data in the worksheet, I receive the following message from Excel that has to be manually responded to:
"Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete."
Is there any way to override this message automatically and force the deletion of the worksheet even if there is data on it so the end user will not see this message and have to respond?