Click cell to print?

B

Bob

Is it possible to have something in the corner of every page break (being71
rows a 8 columns)
that if clicking it will print down 71 rows a 8 columns
Something that wont print out either!

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
A

Arvi Laanemets

Hi

Write a procedure/macro, which will print wanted range relatively to cell
reference parameter
Insert command buttons from Forms toolbar into worksheet (one for every page
break), and attach the procedure to them (with different cell reference as
parameter for every call)
 
B

Bob

I cant use the (76,8) Row Column for each macro?

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
A

Arvi Laanemets

Hi

Use Offset
You send reference (let's be p.e. StartCell) to leftmost upper cell of
section as parameter to procedure.
The print area will be
Range(StartCell).Offset(65,8)
 
A

AlfD

And, whether you use a button from the Control Toolbox or the For
Toolbox, remember to set its Properties to include "not a prin
object"

Al
 
B

Bob

What I would like to do is put a tick box in the corner of each (72,8) page
breaks so as when they have a tick in them it will print the (72,8) from the
tick box then the tick disappears, Could you give me a easy steps towards
this..Please

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Top