I'd create a dedicated macro and then put a button from the Forms toolbar onto
that sheet and assign the macro to this button.

Option Explicit
sub PrintMe()
with activesheet
if isnumeric(.range("I3").value) then
.range("I3").value = .range("I3").value + 1
.printout preview:=true
else
Beep
msgbox "I3 isn't a number!"
end if
end with
end sub

mceder1 wrote:

I would like to have excel auto number a new work sheet every time I print a
new sheet. The form that I have created has the page numbers in cell I3 and
only has to number from 7 to infinity.
--
Matt

--

Dave Peterson