Hi Ray

I will check that out today and when it is ready you can download the file
from Debra's site so that there are two versions on that page.

I will post it here when it is online


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ray" wrote in message ...
hi ron -

my comments on .... ?

My experience with the code (as written) is that if I change windows
(ie workbooks) and then use the NavToolBar to select a sheet (without
refreshing), the code will kick me into previously selected workbook.
An annoyance at times, but my own fault for now 'refreshing' ...
however, if there's a way to auto-refresh upon changing active
workbooks, that'd be even better!

//ray