Question: Open a new workbook and make sure it has two worksheets in it named Sheet1 and Sheet2. Write a sub that has three lines. The
Open a new workbook and make sure it has two worksheets in it named Sheet1 and Sheet2. Write a sub that has three lines. The first should be Application.DisplayAlerts = False. (See section 5.13 to recall what this does.) The second line should delete Sheet2, and the third should delete Sheet3. What happens when you run the program? Change your code so that if it tries to delete a worksheet that doesnt exist, nothing happensand no error message appears.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
