Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to Place Public Subs and Functions
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Common Functions and Subs | Excel Discussion (Misc queries) | |||
Called subs versus functions | Excel Programming | |||
Public Functions As Worksheet Available Functions | Excel Programming | |||
Calling VBA add-in functions/subs from another Excel file. | Excel Programming |