Where did you put the Workbook_Open event? It must go in the
ThisWorkbook code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Neil Hopkinson" wrote
in message
...
it doesn't seem to work though, any more ideas?

"Neil Hopkinson" wrote:

that's exactly what I mean, thanks

"Charlie" wrote:

If you mean when you open an existing workbook try putting
your code in:

Private Sub Workbook_Open()

End Sub


"Neil Hopkinson" wrote:

Is it possible to set up a macro that automatically runs
when you open excel?

Thanks