Printing. If you press the button, Excel will print all the contents of the worksheet shown on the screen or according to the options that you have chosen in the page layout. You can however control some options for printing. The next part explains these options. From the File menu, select the Print option.

Here is a sample of what you will find in lesson 15 of the downloadable Tutorial on Excel macros. Lesson 15 on Excel Macros (VBA): VBA Code for Worksheets. To develop a VBA procedure that is triggered by an event relating to the worksheet (when you select it, when you leave it...) see the VBA lesson on events. Sheets Re: Printing multiple sheets from VBA I solved this problem! Turns out I can accomplish everything I need to but only if I use VBA to do the page setup for every sheet just before they are printed.