Unknown sheet in Project Explorer

  • Thread starter Thread starter Saucer Man
  • Start date Start date
S

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)?
 
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
 
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?
 
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.
 
Great. Thanks a lot.


Dave Peterson said:
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.
Click to expand...
 
Back
Top