Nathan,

ThisWorkbook is a class module, a very special class module. With class
modules, code is only accessible via a class identifier.

As I suggested, some code is best placed there, some is better in a standard
code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"nathan" wrote in message
...
Forgive me for not having much experience with coding and the different
types of modules. If I am understanding your question correctly, all of the
code (procedures) is located in the same module which is in ThisWorkbook.
As far as I can tell the module is a standard module (as opposed to a class
module). Should some of the code be in separate modules?

FYI - I am using ThisWorkbook.name because the workbook is constantly
being saved under a new name. I want the procedures to work in the new
named workbooks and this way I don't have to change the code to reflect the
new name. That's the idea anyway.

thanks for your help.