Vb.Net - Excel Deleting Sheets

Good Day Experts!

I have an application here with a TabControl and 21 tabs.  The majority of them output to Excel from a DataGrid. Behind the ExcelOutput button click, I delete the 2 extra sheets that aren't needed before I make the spreadsheet visible.  When I run it locally here in my development environment, I am not prompted with the "Are you sure you want to delete this sheet" messagebox.  However, when I publish it, the User is prompted for each sheet.

Is there a way for them to not see the messages?

Thansk,
jimbo99999
Jimbo99999Asked:
Who is Participating?
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
I suppose, you've done this before calling the delete method (I know, this may be "stupid" question) ;-)

    Application.DisplayAlerts = False

Open in new window

0
 
Jimbo99999Author Commented:
Hello, thanks for repsonding.  I have not done that...I never knew about it.  I will try it.
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
BUT: set back to True once you've done your "work" ;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.