Referencing selected tabs to print selection & update table of contents sheet

[ML!]

Hi all...I searched but didn't find exactly what I needed. I have a workbook with 31 sheets. It is a price guide with each category on a separate worksheet. I figured out how to list the sheets on a separate tab. What my client wants is the ability to:

1. select certain categories for printing, the ToC, Cover and backcover pages have to print in every case

2. the ToC has to change depending on the sheets selected.

I'd rather write some code and give him an an easy command button rather then teaching him how to select non-concurrent sheets and printing only active sheets.

What I'm really stuck on is the updating of the ToC with active sheets only (category and starting page which changes depending on pages selected).

Thanks in advance for any brilliant ideas!

ML

 

[Zack Barresse]

The number format trick should get it to look uniform without having to do any manual spacing or anything, getting it aligned. Glad it works for you!!