Classes
Class module

Event Related Code (except classes)
Workbook level events : ThisWorkbook module
Sheet level events: Sheet module associated with the sheet
ActiveX Controls on Sheets events: Sheet module associated with the sheet
they are on
Userform/controls on userforms: Userform module
Forms Toolbar controls: General Module
Commandbar OnAction Macros: General Module

Everything else should go in a general module
including user defined functions to be used in a worksheet.

http://groups.google.com/groups?selm...&output=gplain


http://groups.google.com/groups?selm...&output=gplain

http://groups.google.com/groups?selm...&output=gplain

--
Regards,
Tom Ogilvy


"Ross" wrote in message
om...
hi there,

could someone tell me the difference between putting a sub in a
worksheet specific code module and a general module?

When I hope my spreadsheet, then do alt-f11, I see Sheet1 with a place
for code, as well as a Module1 that takes code. Sometimes I find that
if I am trying to call a procedure from within Sheet1 code, it won't
find it unless I put the called procedure in the Module1.

I know this must be very basic stuff for Excel. A brief explanation
would be appreciated!

Thanks
Ross