Print area
I have a number of sheets in a workbook that require
certain users to print certain areas. Many of the users are not used to working with excel and need just one button to press. Can anybody give me the script for print area. The button will be on a different page to the print area. Cheers Jez |
Print area
Hi
one way: record a macro: - goto 'Tools - Macro - Record macro' - do your stuff :-) - stop the recording Now you can ssign this code to a button or invoke it from the macro menu -- Regards Frank Kabel Frankfurt, Germany "Jez" schrieb im Newsbeitrag ... I have a number of sheets in a workbook that require certain users to print certain areas. Many of the users are not used to working with excel and need just one button to press. Can anybody give me the script for print area. The button will be on a different page to the print area. Cheers Jez |
Print area
No that won't work I need the buttons on a different page to the print area. -----Original Message----- Hi one way: record a macro: - goto 'Tools - Macro - Record macro' - do your stuff :-) - stop the recording Now you can ssign this code to a button or invoke it from the macro menu -- Regards Frank Kabel Frankfurt, Germany "Jez" schrieb im Newsbeitrag ... I have a number of sheets in a workbook that require certain users to print certain areas. Many of the users are not used to working with excel and need just one button to press. Can anybody give me the script for area. The button will be on a different page to the area. Cheers Jez . |
Print area
Hi
it would :-) try the following - put a button on your other sheet - insert the following code for the click event of this button (change the worksheet name and the range definition to your needs) ---- Dim wks as worksheet set wks = Activeworkbook.worksheets("Print_Sheet") wks.PageSetup.PrintArea = "$A$1:$D$17" wks.PrintOut Copies:=1, Collate:=True ---- -- Regards Frank Kabel Frankfurt, Germany "Jez" schrieb im Newsbeitrag ... No that won't work I need the buttons on a different page to the print area. -----Original Message----- Hi one way: record a macro: - goto 'Tools - Macro - Record macro' - do your stuff :-) - stop the recording Now you can ssign this code to a button or invoke it from the macro menu -- Regards Frank Kabel Frankfurt, Germany "Jez" schrieb im Newsbeitrag ... I have a number of sheets in a workbook that require certain users to print certain areas. Many of the users are not used to working with excel and need just one button to press. Can anybody give me the script for area. The button will be on a different page to the area. Cheers Jez . |
Print area
Thanks....
Worked like a charm.... -----Original Message----- Hi it would :-) try the following - put a button on your other sheet - insert the following code for the click event of this button (change the worksheet name and the range definition to your needs) ---- Dim wks as worksheet set wks = Activeworkbook.worksheets("Print_Sheet") wks.PageSetup.PrintArea = "$A$1:$D$17" wks.PrintOut Copies:=1, Collate:=True ---- -- Regards Frank Kabel Frankfurt, Germany "Jez" schrieb im Newsbeitrag ... No that won't work I need the buttons on a different page to the print area. -----Original Message----- Hi one way: record a macro: - goto 'Tools - Macro - Record macro' - do your stuff :-) - stop the recording Now you can ssign this code to a button or invoke it from the macro menu -- Regards Frank Kabel Frankfurt, Germany "Jez" schrieb im Newsbeitrag ... I have a number of sheets in a workbook that require certain users to print certain areas. Many of the users are not used to working with excel and need just one button to press. Can anybody give me the script for area. The button will be on a different page to the area. Cheers Jez . . |
Print area
Or
Worksheets("Print_Sheet").Range("a1:d17").PrintOut Copies:=1 -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl wrote in message ... Thanks.... Worked like a charm.... -----Original Message----- Hi it would :-) try the following - put a button on your other sheet - insert the following code for the click event of this button (change the worksheet name and the range definition to your needs) ---- Dim wks as worksheet set wks = Activeworkbook.worksheets("Print_Sheet") wks.PageSetup.PrintArea = "$A$1:$D$17" wks.PrintOut Copies:=1, Collate:=True ---- -- Regards Frank Kabel Frankfurt, Germany "Jez" schrieb im Newsbeitrag ... No that won't work I need the buttons on a different page to the print area. -----Original Message----- Hi one way: record a macro: - goto 'Tools - Macro - Record macro' - do your stuff :-) - stop the recording Now you can ssign this code to a button or invoke it from the macro menu -- Regards Frank Kabel Frankfurt, Germany "Jez" schrieb im Newsbeitrag ... I have a number of sheets in a workbook that require certain users to print certain areas. Many of the users are not used to working with excel and need just one button to press. Can anybody give me the script for area. The button will be on a different page to the area. Cheers Jez . . |
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com