asked on

MS excel 2010 button to print only certain sheets and sections of workbook

Hello!

I have created a button that I want to allow the user to be able to print just certain sheets of the workbook. I am wanting to create a macro for the button that prints columns A-J, but NOT column C, from the worksheet "summary". Then I would also like the worksheet called "service rates" to print right after the "summary" sheet. It would also be great if both sheets fit to the page so that they aren't being cut off!

Thanks so much :)

SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jane Kisbey

ASKER

Okay great, thank you so much! Now that I am thinking about it, it might actually be better to export columns A-J, except column C in the "summary" sheet and then all of the "service rates" sheet into a PDF, rather than printing them. Sorry, I should have thought of that earlier! Would the code be quite similar for that?

SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jane Kisbey

ASKER

Here is the dummy workbook. What I would like is that when the Print Bid button is clicked columns A-J except column C on the "summary" sheet and then also the "service rates" sheet would be exported as a PDF. Thanks!
databaseexample.xlsm

ASKER CERTIFIED SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jane Kisbey

ASKER

Okay, I wanted to get this done by today for my boss so I have posted another question with some of the changes. But thank you so much for your help!!

Jane Kisbey

ASKER

Thank you!

Roy Cox

Pleased to help