Excel Workbook with Extra Sheets Shown Thisworkbook

[cyliyu]

I have an Excel workbook.
In VBE, I found additional "sheets" and then when go into the properties windows, they shown me "Thisworkbook" too.
How to remove them?

 

[Hui]

Make sure the workbook is selected
In the Immediate windows type
Worksheets("Sheet091").Delete

But better to do it from the Workbook rather than VBA
If you have the wrong file active, you may inadvertantly delete worksheets you didn't intend to

 

[cyliyu]

having a Run-time error '9'

 

[vletm]

cyliyu
Your snapshot shows that You do not have sheet, which name is Sheet091, sheet's name is like ( sheet name ).
You could eg manually rename that Sheet with Your 'left bottom window'.

 

[cyliyu]

Thanks, All.
I have fixed the errors.

 

[Hui]

You copied my code and it made slanty " not regular "

 

[AmosChow]

I created a new Excel workbook and copy all the sheets to the new workbook and save as a new copy. Apologies didn't mention it in my previous post. Thanks.

 

[vletm]

cyliyu & AmosChow
Interesting, that You both has same Content IP ...

 

[cyliyu]

My apology, didn’t notice I am not using my own account as I am using my relative mobile device to reply the message.