On Jan 23, 11:19*am, ypukpete
wrote:
Thanks mate, works like a charm in my application. But can you explain what
you mean by an Auto macro. I am fairly new to VBA etc. Thanks for your help.
--
ypukpete


Basically, anything you code into a macro called "Sub Auto_Open" will
be actioned automatically as soon as the spreadsheet is opened - you
don't need to invoke it.

Good luck,
Aussie Dave