| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unknown sheet in Project Explorer
Great. Thanks a lot.
"Dave Peterson" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA project duplicated in Project Explorer | Excel Programming | |||
| Sheet disappears from Project Explorer | Excel Programming | |||
| Project still in "project explorer" window after file closed down! | Excel Programming | |||
| Project still in "project explorer" window after file closed down! | Excel Programming | |||
| VBA Project Explorer | Excel Programming | |||
Hybrid Mode
