And you learn something new each and every day... Thanks...

"JE McGimpsey" wrote:

Actually, it *can* reside in the ThisWorkbook module (which is also a
"Module" - it's just a special instance of a class module, rather than a
regular/standard module). To use it, though, the reference has to
include the class name, e.g.:

Workbook1.xls!ThisWorkbook.foo

In article ,
"Jim Thomlinson" wrote:

The sub called by OnAction has to reside in a Module. It can not reside in
ThisWorkbook or a sheet. Just the way it works. You could put a public sub in
a module that calls a sub in thisworkbook if you want to.