Maria,

when accessing the book the code is in, use:

ThisWorkbook.Sheets("index"). - and so on -

Pete.

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