Creating a Print Button

Hi All,

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

Cheers
Will

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

On Wed, 21 Jun 2006 18:45:24 -0500, william4444
<[email protected]> wrote:

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

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.

--
Hope this helps,
MarkN


"william4444" wrote:

>
> Hi All,
>
> Hope things are well... Anyway i have an Excel Spreadsheet with 12
> sheets inside & on the First Sheet i'd like a Button that would print
> all the sheets after each other. How do i do this i've never used a
> Macro. Would appreciate all the help.
>
> Cheers
> Will
>
>
> --
> william4444
> ------------------------------------------------------------------------
> william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991
> View this thread: http://www.excelforum.com/showthread...hreadid=554361
>
>

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