thanks for catching that. It is something I have known and often forget.

"Gord Dibben" wrote:

bj and Duggan

BeforePrint is workbook code and will not run from a sheet module.

Must go into Thisworkbook module.

Right-click on the Excel Icon left of "File" on the main menu in Excel or on the
Excel Icon at left side of Title bar if not maximized.

Select "View Code" from the dropdown.

A module will open.

Paste the code into that module. Save and close then re-open.


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 14:22:03 -0700, bj wrote:

go to the sheet you want it to work in and right click on the tab
selecy view code
paste the sub in the module

again make sure the Sheet_name is the name you have for the sheet
and the cell reference is the cell in which you will have the name.