Excel 2003. I have a multisheet workbook. Each sheet has many controls that
call some VBA code. Many of the subroutines and functions performed are
common to every sheet. I am presently duplicating the code for each sheet.
Where may I place these subs and functions so that they may become public,
and thus eliminate the duplication of code? I tried placing them in the
"code page" associated with "ThisWorkbook" and declaring them public. But
when I try to call these "public" routines from the individual sheets, they
cannot be found. What am I doing wrong?

By the way, what do you call the "code page" associated with inidivual
sheets and the "code page" associated with "ThisWorkbook"?
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org