-
I'm using following syntax to delete an Excel sheet from within VB.
obExcelProg.Sheets(3).Delete
But before the sheet is removed a messagebox appear asking the user to hit OK to delete the sheet or cancel to ignore the process.
What can I do to not display the message to the user?
-
Solution
I were too fast asking you guys for help.
This question were already asked and answered.
Here is what I ended up doing:
obExcelProg.DisplayAlerts = False
obExcelProg.Sheets(3).Delete
obExcelProg.DisplayAlerts = True