|
|
#1
08-29-2010, 10:35 PM
|
|||
|
|||
Delete sheet through VBA
I am unable to delete a worksheet in excel (office-2003) contaning data on it.
pls help 
|
|
#2
08-30-2010, 09:11 AM
|
||||
|
||||
|
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 |
Windows XP 
Office 2003
Linear Mode
