View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default Where Macros Are Located

Absolutely, it does. You also left out Userforms, and class modules.
Most macros are written in modules.
Event-driven macros (like selecting a cell, or closing a workbook) are
written either in the sheet or workbook, depending on the event. Workbooks
have their specific set of events which are separate events from the
workbook (thisworkbook) events.
If you place your macros in a place they don't belong, they either won't
run, or will produce unexpected results.


"George B" wrote in message
...
I've noticed in VBE that there are a number of locations where macros may

be
created and executed:

1. Each sheet can contain macros
2. There is something called ThisWorkbook
3. There can be a number of modules

Does it make any difference where I put my code?