Creating a Print Button

[william4444]

Hi All,

Hope things are well... Anyway i have an Excel Spreadsheet with 1
sheets inside & on the First Sheet i'd like a Button that would prin
all the sheets after each other. How do i do this i've never used
Macro. Would appreciate all the help.

Cheers
Wil

 

[Gord Dibben]

Why would you need a macro when you can hit File>Print>Entire Workbook?

Or just hit the Printer Icon and select Entire Workbook?


Gord Dibben MS Excel MVP

 

[MarkN]

Hi Will,

To record the macro you need to turn on the macro recorder, perform the task
and then turn off the mcro recorder:

Tools, Macro, Record New Macro.
Use the mouse to simulate the printing of the sheets.
Click the 'Stop' button on the Stop Recording toolbar.

To attach this macro to a button:

Open the forms toolbar, click on the button and draw it out where you want
it. The Assign macro box lets you assign a macro to the button so select the
required macro and click OK.

 

[william4444]

Just like to say thank you to Both MarkN & Gord both helpful. I ended up
useing the Macro really cool though the other Tip was good to, can't
believe i never saw the little button. Thanks both.

Cheers
Will