How to put a 'PRINT' button on excel sheet?

Dear Expert,

How can I put a 'print' button on excel sheet to get my docs printed immediately.

thanks

This is one way to do it.

1. Towards the top left hand corner of the EXCEL window click on:-

Customize Quick Access Toolbar

 - then click on:-

More Commands . . .

The:-

Excel Options

 - window should open.

2. In the:-

Excel Options

 - window in the:-

Choose commands from:

 - section click on:-

All Commands

3. Now in the box immediately below scroll down to:-

Print

 - and click that option so it's highlighted.

4. Click on:-

Add>>

 - towards middle of the window.

You should see:-

Print

 - on the right hand side.

Click:-

OK

5. A:-

Print

 - icon should now have been added to your:-

Quick Access Toolbar

6. Click that:-

Print

 - icon to open the:-

Print

 - pop up window.

Does that give you what you want?

Hi,

select cell B2 and run this code...

Sub AddNewButtons()

On Error Resume Next

Dim rng As Range

Set rng = Selection

For Each r In rng

ActiveSheet.Buttons.Add(r.Left, r.Top, r.Width, r.Height).Select

r.Placement = xlMoveAndSize

Next

rng.Select

End Sub

now, 

right click on Button and assign macro.

Note

you can select more than one cells.

Dear Expert,

How can I put a 'print' button on excel sheet to get my docs printed immediately.

thanks

 

This is one way to do it.

 

1. Towards the top left hand corner of the EXCEL window click on:-

 

Customize Quick Access Toolbar

 

 - then click on:-

 

More Commands . . .

 

The:-

 

Excel Options

 

 - window should open.

 

2. In the:-

 

Excel Options

 

 - window in the:-

 

Choose commands from:

 

 - section click on:-

 

All Commands

 

3. Now in the box immediately below scroll down to:-

 

Print

 

 - and click that option so it's highlighted.

 

4. Click on:-

 

Add>>

 

 - towards middle of the window.

 

You should see:-

 

Print

 

 - on the right hand side.

 

Click:-

 

OK

 

5. A:-

 

Print

 

 - icon should now have been added to your:-

 

Quick Access Toolbar

 

6. Click that:-

 

Print

 

 - icon to open the:-

 

Print

 

 - pop up window.

 

Does that give you what you want?

 

No Sir, I want the print button on B2 on excel sheet, not as quick access tool, thanks to respond

Dear Expert,

How can I put a 'print' button on excel sheet to get my docs printed immediately.

thanks

Word deal in "docs".

Excel deals in workbooks and worksheets with possibly multiple print ranges on each worksheet.

What exactly will you be printing? Entire workbook?  One or several worksheets?  Ranges from worksheets?  User selections?

You want a button on "excel sheet", but which sheet?

"printed immediately".  What provision have you made for page setup?

Gord