Thanks a lot folks - knew it was something like that!

Mike


"Bob Phillips" wrote in message
...
Mike,

Naming the macro Auto_Open is the old (tried and trusted) way, and goes
in
a standard code module, but when events made their appearance we got
Workbook_Open, which goes in the ThisWorkbook module.

A thing to note about Auto_Open is that it does not get run if a workbook
is
opened from VBA, so you would need to do it explicitly with "RunAutoMacros
xlAutoOpen"

--

HTH

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

"Mike Boardman" wrote in message
...
I really ought to know this but I have completely forgotten how to do
it.

I'm sure it's something to do with switches or namng the macro, but none
of
the methods I have tried work.

Can anyone help me out please? TIA