View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Unknown sheet in Project Explorer

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 wrote:

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?

wrote in message
...
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


--

Dave Peterson