| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
| File, print area, clear area, is not working | New Users to Excel | |||
| print area across the freeze panes area | Excel Worksheet Functions | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
![Jez[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
