Printing question

[taliesin42421]

Hello. I have a printing question. I created an .xls file with four worksheets. The first is for inputting data from a survey. It's 240 questions and there is a column that sums everything up. That is the ONLY worksheet that I want users to have access to. The third and fourth sheets are converted t scores from the raw data collected on sheet 1. They are locked and/or hidden. The second sheet is also locked, but it is the sheet that I want printed. It has the data that is needed and line charts. As I said, I do not want users to access pages 2, 3 or 4. I only want them to enter data on page 1 and hit the print button which ideally would then print page 2. Is there any way to print page 2 only from page 1? Thank you!

[xladept]

Hi Taliesin,

Welcome to the Forum!

Try this in your button code:

Please Login or Register  to view this content.

*If the sheet has a different name then put it in quotes instead of the red

[taliesin42421]

Nailed it! Thanks! I have never used button codes before but I think that's about to change! Thanks again

[xladept]

You're welcome and thanks for the rep!