Print specific section of specific hidden worksheets

I would like to create a command button that will print off specific hidden worksheets however, I only need to print off a specific section of each worksheet and I would like it to fit each worksheet on one page.

I have several (~30) worksheets that must be accessed individually through a command button, and will hide again when not active. My goal is to allow a feature that can print off all the hidden worksheet if desired, however if used then not all the worksheet needs to be printed off. Only certain columns.

Here is the code I'm trying to use:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

In essence, I'm trying to tell Excel (unsuccessfully): "With command button 20: print off columns B through E of these worksheets on separate pages and autofit to 1 page per section."