Table of Contents Code Addition

[Building]

Hello,

I have a worksheet that uses a table of contents code that was provided by a user on this forum.

Once the table of contents sheet has been generated, I'd like to have a macro allow me to choose from a drop down menu a list of the sheets in order to print only that sheet. I have the code working using data validation, but I have to manually enter the name of each sheet rather than relying on the automatically generated table of contents.

Essentially I'd like to have the printer macro reference the table of contents to allow a user to print the selected sheet based on available sheets listed in the table of contents.

I have attached my workbook.

Printer Macros.xlsm

[jaslake]

Hi Building

Not sure exactly where you're going with this.

Create a Dynamic Named Range called "Sheets" with this Code in ThisWorkbook.Open Event

Please Login or Register  to view this content.

Add these lines of Code to the CreateTOC Code

Please Login or Register  to view this content.

Change Data Validation for Summary Cell B2 to =Sheets

See attached.

[Building]

Works perfectly, however the print function's code does not update to reflect added sheets. The code for the print button is as follow:

Please Login or Register  to view this content.

The code prints the selected sheet based off of the data validation from cell B2. Is there a way for the printer code to also update to reflect sheets added to the Table of Contents?

[jaslake]

Hi Building

Try this

Please Login or Register  to view this content.

[Building]

Worked perfectly, thank you!

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.