I would try to move the scroll bar a hair more to the right. If the scroll
bar is very close to your last tab then if you activate that worksheet will
will shift the tabs to the left.

It may help!
--
Cheers,
Ryan


"Sandy" wrote:

I have a workbook with eight visible sheets. The horizontal scroll has been
resized to allow all tabs to be visible - however when code is run on sheet
8 "Search Rounds" the first three sheet tabs disappear to the left.

They can be easily made visible by clicking on the 'Navigation' buttons - so
it is just a minor niggle - but is there any way to force all tabs to be
visible at all times? I suspect if there is it will be thro VBA.

Thanks
Sandy