As always, post YOUR code for comments. Saves time and effort

--
Don Guillett
SalesAid Software

"Chaplain Doug" wrote in message
...
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