Thanks for your help.
Has made a big difference to my application.
Keep an eye open for me...I sometimes ask questions I cant find
in the threads. but I go through them all first before I ask.
Nice to know there are people willing to help.
--
ypukpete


"AussieDave" wrote:

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