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