ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to add a print tab or button in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/50753-how-add-print-tab-button-cell.html)

SimonJ

how to add a print tab or button in a cell
 
Im wanting to add a print button on to a excel spreadsheet cell, so you
click on the cell (which would say PRINT ME) and the document prints out.
Its for a spreadsheet at work. So they dont have to click on file, print or
on the tab at the top of the screen€¦€¦€¦..Ya I know but the powers that be have
asked.

Ive had a look on the net but cant find anything thatll show me, Can
anyone help?


Dave Peterson

how to add a print tab or button in a cell
 
You could record a macro when you print what you want manually.

Then drag a button from the Froms toolbar onto that worksheet. And assign your
recorded macro to that button.

SimonJ wrote:

Im wanting to add a print button on to a excel spreadsheet cell, so you
click on the cell (which would say PRINT ME) and the document prints out.
Its for a spreadsheet at work. So they dont have to click on file, print or
on the tab at the top of the screen€¦€¦€¦..Ya I know but the powers that be have
asked.

Ive had a look on the net but cant find anything thatll show me, Can
anyone help?


--

Dave Peterson


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com