View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ross[_5_] Ross[_5_] is offline
external usenet poster
 
Posts: 5
Default different places to put excel code?

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