Unknown sheet in Project Explorer

[Saucer Man]

I have an Excel Workbook with 3 sheets, Jan, Feb, & Mar. When I look in
Project Explorer, I see an unknown sheet under Microsoft Excel Objects. It
shows...

Sheet1 (Jan)
Sheet2 (Feb)
Sheet3
Sheet4 (Mar)
ThisWorkbook

I don't know what Sheet3 is. When I click on it, the Properties window
shows the same properties as when I click on ThisWorkbook. If I make a
change in the properties, the change is seen both when I click on Sheet3 and
ThisWorkbook. How do I delete Sheet3 and make it so Sheet4 (Mar) becomes
Sheet3 (Mar)?

 

[hewett_nick]

Very odd!

I'm thinking corrupt workbook.

If you right-click and choose view code do you see the same module
sheet as ThisWorkbook?
How was this workbook created and how long ago?
Regardless of the answers to the above, I'd be tempted to start afresh
by copying the sheets 1, 2 and 4 to a new workbook where you can
rename Sheet4 to Sheet3 in the Properties window.

Br, Nick H

 

[Saucer Man]

The workbook was created in January but I have run several macros that could
have corrupted it. How can I copy sheets 1,2, & 4 and retain the column
widths, formulas, and conditional formatting that I have?

 

[Dave Peterson]

Select the sheets
and edit|move or copy sheets
choose a new workbook
and choose copy

And don't forget to drag all the modules/userforms/class modules from the
original workbook's project to the new workbook's project.

 

[Saucer Man]

Great. Thanks a lot.

Select the sheets
and edit|move or copy sheets
choose a new workbook
and choose copy

And don't forget to drag all the modules/userforms/class modules from the
original workbook's project to the new workbook's project.