VBA & delete tab

[Sharp]

Hi,

i have set-up some code that when the file closes a tab is auto deleted and then the file saves itself. However excel still produces the following msg for the user

'Data may exist in the sheet for deletion. To permanetly delete the data, press delete'

Is there a way to ensure this msg does not appear and therefore the user doesn't have a choice of the tab being deleted

thanks

[mudraker]

Add this line of code before deleting the sheet

Please Login or Register  to view this content.

Add this after deleting the sheet

Please Login or Register  to view this content.