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
print
area. The button will be on a different page to the
print
area.

Cheers

Jez

.