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?

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?

See Chip Pearson's discussion:
http://www.cpearson.com/excel/codemods.htm

Regards,
Greg

-----Original 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?


.

Thanks -- that reference was a big help.

George Borrmann

"Greg Wilson" wrote in message
...
See Chip Pearson's discussion:
http://www.cpearson.com/excel/codemods.htm

Regards,
Greg

-----Original 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?


.