Need help creating a print button for an excel workbook?

Question

I have a workbook with a lot of different reports in it, as well as multiple table of contents pages. On each one of these TOC pages I need a print button that prints specified reports (with specified print areas). Any help, or resources would be greatly appreciated!

Answer 1

You could probably use a macro to do this. Right-click up on the toolbars and turn on the Control Toolbox. Then, on the Control Toolbox, click Design Mode. Click Command Button, then drag and drop over the area where you want the Print Button to be. Right-click the Command Button, click View Code, and add your print macro data and range. Click OK.

Hope that helps!