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