Sheets not deleted

[0 Agios]

http://www.bryantelectricestimating.com/Sheets not deleted.JPG
In the work book sheets 100,101,103 etc dont show and are deleted
Why do they show in VBA ?
Sheet 1 (Instructions) is a normal pageand shows in the workbook.
Thanks.

 

[VoG]

Are you sure they aren't hidden?

 

[0 Agios]

Are you sure they aren't hidden?

Yes 100% because I have hiden other pages.

I deleted this pages using this code, is this the problem ? and when I click on them the page has code.

Private Sub Label142_Click()

ActiveWindow.SelectedSheets.Delete
DisplayAlerts = False
Unload Me

End Sub

 

[Norie]

That looks very strange.

You don't seem to have a ThisWorkbook module.

Also, all the other modules appear to be workbook modules apart from Sheet1(Instructions) and Sheet129(RevCo).

What worksheets are you trying to delete/keep?

 

[0 Agios]

That looks very strange.

You don't seem to have a ThisWorkbook module.

Also, all the other modules appear to be workbook modules apart from Sheet1(Instructions) and Sheet129(RevCo).

What worksheets are you trying to delete/keep?

Delete sheets 100, 101, 105
Sheet 1, sheet 129 are normal