none
How to add new sheets to document-level project? RRS feed

  • Question

  • I'm trying to add new sheets to a document-level Excel project.  

    According to the documentation, "In document-level projects, you can add additional Worksheet host items to the project at design time by adding a new worksheet to the workbook in the designer.".  When I open the workbook designer, I get a window that says "This is the workbook designer: ...".  And it basically says to add components from the Toolbox.  But there is no obvious way to add a new sheet from the Toolbox.

    Right clicking on Workbook.xlsx and ThisWorkbook.cs also do not have any sheet related options.  How can I add a new sheet?

    Thanks,

    Ed

    Friday, October 4, 2019 2:57 PM

All replies

  • I just created a new project, and this time started from an existing Excel document.  This new project has options to add new worksheets when right clicking the Workbook in the solution explorer.  My other project doesn't.
    Friday, October 4, 2019 3:26 PM