Hello,
I have a routine that unhides some sheets. This works ok.
The only issue it has, is that some sheets are "hidden" behind the scroll box.
So i need to scroll (that is the little "scroll bar thing" at the bottom left of Excel 2007) towards my unhidden sheets to make them "visible".
Aint it possible to unhide the sheets and centre them, so I can see all the unhidden sheets' sheet tabs? Without having to "scroll" for them ...
As always, I hope someone understands what I try to accomplish here^^
Thanks for your assistance,
Sige
I have a routine that unhides some sheets. This works ok.
The only issue it has, is that some sheets are "hidden" behind the scroll box.
So i need to scroll (that is the little "scroll bar thing" at the bottom left of Excel 2007) towards my unhidden sheets to make them "visible".
Aint it possible to unhide the sheets and centre them, so I can see all the unhidden sheets' sheet tabs? Without having to "scroll" for them ...
As always, I hope someone understands what I try to accomplish here^^
Thanks for your assistance,
Sige