Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET
i am creating a workbook and want to put a print button on the top of each
page that functions, please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET
create the button and assign a macro: "Worksheets("sheetx").Printout copies:=1" -- protonLeah ------------------------------------------------------------------------ protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097 View this thread: http://www.excelforum.com/showthread...hreadid=531247 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET
dlc-forbes,
Sub print_sheet() ActiveSheet.PrintOut Copies:=1 End Sub To put in this macro, from your workbook right-click the workbook's icon and pick View Code. This icon is to the left of the "File" menu this will open the VBA editor, in Project Explorer click on your workbook name, if you don't see it press CTRL + r to open the Project Explorer, then go to insert, module, and paste the code in the window that opens on the right hand side, press Alt and Q to close this window and go back to your workbook. To put the button on your sheet, view, toolbars, forms, click on the button then click on your sheet where you want the button, a box will come up to assign a macro, pick print_sheet from the list, OK change the name on the button if you want to, right click on it to do this. If you are using excel 2000 or newer you may have to change the macro security settings to get the macro to run. To change the security settings go to tools, macro, security, security level and set it to medium -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "dlc-forbes" wrote in message ... i am creating a workbook and want to put a print button on the top of each page that functions, please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a function to copy an entire worksheet? | Excel Worksheet Functions | |||
Is there any way to make buttons copy from one worksheet to anothe | Excel Worksheet Functions | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
command button in excel will move when print. | Excel Discussion (Misc queries) |