Hi I have a macro which inserts a new worksheet at the end of the workbook
but the problem is when I click on cancel in the Inputbox it needs
debugging.

How can I change the code below to remove that particular worksheet when the
cancel button is pressed on the inputbox.

Worksheets.Add.Move after:=Worksheets(Worksheets.Count)
Dim NAMED As String
NAMED = InputBox("WHAT IS THE NAME OF THE WORKSHEET?")
ActiveSheet.Name = NAMED


Thanks

greg