Actually, since this is workbook_beforeprint, the code goes into the
ThisWorkbook module.

swatsp0p wrote:

Dave and Bob: Thank you both for your replies. I have tried both
examples, and still no header appears (either in print preview or on
the actual printout).

I pasted your codes (adjusting sheet reference as needed to "sheet3")
into the sheet3 General window (right click on sheet tabView Code and
paste there). Placing this code in "this workbook" doesn't work either
(of course).

What am I still missing? (I'm sure I'll slap my forehead when I see how
easy this should have been for me).

Again, thank you for your time.

Bruce

--
swatsp0p

------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=512417

--

Dave Peterson