you need to use the Thisworkbook to refer to the workbook where the macro is
located. and Activeworkbook where the macro is working on.


Cesar


"Maria" wrote in message
...
How does a macro access its OWN workbook (the workbook where the macro is
defined), even when this is not the active workbook?
I want to create a read-only 'reference' workbook that contains a
collection of macros and a couple of worksheets with reference data. The
various reference worksheets will have fixed names, but I want to avoid
using a fixed name for the reference workbook.
My users will select some cells in a work-in-progress workbook and then
invoke one of the macros (they will have the reference workbook open at the
same time). The macros will need to access the currently selected cells as
well as the reference data.

Any help appreciated
Maria