Click cell to print?

  • Thread starter Thread starter Bob
  • Start date Start date
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
..
..
..
..
 
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)
 
I cant use the (76,8) Row Column for each macro?

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
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)
 
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
 
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
..
..
..
..
 
Back
Top