Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add print function
I would like to add a print button/link right on my worksheet that will print
some of my sheets but not all in the workbook. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add print function
That's easy enough to do but you will have to furnish the sheet names to
print or the sheet names not to print. You would also have to furnish the range to print in each sheet or some logic that Excel can use to find the range to print. HTH Otto "Tim" wrote in message ... I would like to add a print button/link right on my worksheet that will some of my sheets but not all in the workbook. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add print function
Might be just as easy to CTRL + Click on the sheet tabs to print and
FilePrintActive Sheets. Or a short macro on a button. Sub Print_Selected() ActiveWindow.SelectedSheets.PrintOut End Sub If you will always be printing the same sheets go with this. Sub print_some() ActiveWorkbook.Worksheets(Array("Sheet1", _ "Sheet4", "Sheet5")).PrintOut End Sub Gord Dibben MS Excel MVP On Thu, 1 Jan 2009 14:13:00 -0800, Tim wrote: I would like to add a print button/link right on my worksheet that will print some of my sheets but not all in the workbook. Any help would be appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add print function
Gord,
I will always print the same sheets. How do I add a button and then put the macro on it? Thanks!! "Gord Dibben" wrote: Might be just as easy to CTRL + Click on the sheet tabs to print and FilePrintActive Sheets. Or a short macro on a button. Sub Print_Selected() ActiveWindow.SelectedSheets.PrintOut End Sub If you will always be printing the same sheets go with this. Sub print_some() ActiveWorkbook.Worksheets(Array("Sheet1", _ "Sheet4", "Sheet5")).PrintOut End Sub Gord Dibben MS Excel MVP On Thu, 1 Jan 2009 14:13:00 -0800, Tim wrote: I would like to add a print button/link right on my worksheet that will print some of my sheets but not all in the workbook. Any help would be appreciated. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add print function
Button on a sheet?
ViewToolbarsForms. Select the button icon then draw a button on your sheet. Right-click and "Assign Macro" Button on a Toolbar? ViewToolbarsCustomizeCommands. Scroll down to "Macros" and select. Drag a Smiley face up to a Toolbar then right-click on it and assign the macro to that. You can change the Smiley to another Icon should you wish and change the Tooltip name also. Gord On Thu, 1 Jan 2009 16:35:01 -0800, Tim wrote: Gord, I will always print the same sheets. How do I add a button and then put the macro on it? Thanks!! "Gord Dibben" wrote: Might be just as easy to CTRL + Click on the sheet tabs to print and FilePrintActive Sheets. Or a short macro on a button. Sub Print_Selected() ActiveWindow.SelectedSheets.PrintOut End Sub If you will always be printing the same sheets go with this. Sub print_some() ActiveWorkbook.Worksheets(Array("Sheet1", _ "Sheet4", "Sheet5")).PrintOut End Sub Gord Dibben MS Excel MVP On Thu, 1 Jan 2009 14:13:00 -0800, Tim wrote: I would like to add a print button/link right on my worksheet that will print some of my sheets but not all in the workbook. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function on the print area | Excel Worksheet Functions | |||
Print and Email Function on spreadsheet | Excel Discussion (Misc queries) | |||
how to do i use a function if cells contain grades A B C f print. | Excel Worksheet Functions | |||
Print Worksheets function needed. | Excel Worksheet Functions | |||
How to enable Excel print function ? | Setting up and Configuration of Excel |