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