What I would like to do is write code for a command button that will
allow me to print out the graph that is on that particular page not the
whole worksheet which is all I can do at the moment.

I interpreted this to mean you wanted one button that printed the approriate
"pages/graphs" based on where the user had the active cell.

If you want five buttons, then just put in simple code like

Private Sub CommandButton1_Click()
Worksheets("Sheet2").Range("A1:M31").Printout
End Sub

Private Sub CommandButton2_Click()
Worksheets("Sheet2").Range("A32:M52").Printout
End Sub

repeat for the other 3 ranges.

--
Regards,
Tom Ogilvy


"Numan " wrote in message
...
Hi Tom,

Again thanks, I can get it to work with limited results,

Every time I assisgn the code (with the new worksheet name - thanks for
that) to one of the 5 print buttons (next to the five graphs) it always
prints off the first graph only. E.G press print button 4 (for graph
4) it prints off graph 1.

You mentioned the word module. I don't have any custom made modules, I
just have my normal 6 woorksheets and This workbook.

Again, any help would be greatly received.

Numan


---
Message posted from http://www.ExcelForum.com/