S
Seeker
I have a workbook with 3 work sheets, first tab is for data input, second tab
is for data maintain, third tab is macro auto add sheet which extract data
from data maintain sheet for reporting purpose. I would like to delete the
third sheet when either users switch to other tab or closing workbook. I get
the “delete†code but don’t know the code when users switch tab or close book.
Application.DisplayAlerts = False
Sheets("Print").Delete
Application.DisplayAlerts = True
is for data maintain, third tab is macro auto add sheet which extract data
from data maintain sheet for reporting purpose. I would like to delete the
third sheet when either users switch to other tab or closing workbook. I get
the “delete†code but don’t know the code when users switch tab or close book.
Application.DisplayAlerts = False
Sheets("Print").Delete
Application.DisplayAlerts = True