#1
|
|||
|
|||
Delete sheet through VBA
I am unable to delete a worksheet in excel (office-2003) contaning data on it.
pls help |
#2
|
||||
|
||||
Use this on any sheet that is not protected:
Code:
Sub RemoveSpecificSheet() Dim DeleteWS As String DeleteWS = InputBox("Which Sheet do you want to delete?") Sheets(DeleteWS).Delete End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Make row in one sheet equal column of another | hypertyper | Excel | 6 | 01-31-2012 03:48 PM |
Any tutorial same as to this excel sheet with code? | Learner7 | Excel | 1 | 05-18-2010 05:31 PM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Template for Noting Sheet. | Goldenbird | Word | 8 | 05-25-2009 05:48 AM |
sheet linking, sorting | nickbfe | Excel | 0 | 05-19-2006 11:00 AM |