Microsoft Office Forums - View Single Post - [Solved] Delete sheet through VBA

Thread: [Solved] Delete sheet through VBA

View Single Post

Old

08-30-2010, 09:11 AM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

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

Cheers,

Reply With Quote