G
Guest
I have a workbook with many reports, charts, and more, each one on a
different worksheet. I want to know how can i make a header, made in only one
worksheet, so that it can be visible on all worksheets (like a floating
window), when i navegate through them? This way, i will see the title and
buttons avaiable in that header/window on all worksheets i have, without
having to copy the same header and objects to all worksheets (what is
impossible, due to the amount of memory the images and buttons in the header
would use). I don't want to print this worksheets with this header, I just
want to "see" (and use) this header on top of all worksheets in this
workbook. Then, if i made any change on that header (what happens
frequently), i would do this only once, and it would be avaiable to the
entire workbook.
My main objective with this header is navigation between worksheets.
What i really want is a floating window for navigation. I tryed this once
with a userform, floating above my worksheets, but the problem was to resize
it to fit the diferent screen resolutions. When i did this some objects and
images became weird. I'd like to do this using a floating worksheet, like a
new window with the AlwaysOnTop property 'true'. I know there is no
AlwaysOnTop property for windows, but that's what best describes what I want
to do, as windows resize ok (no problems with images and other objects with
different ZOOMs).
I'm using Excel 2003 and Windows XP SP2.
Thanks. And, sorry for the poor english.
Glauco.
different worksheet. I want to know how can i make a header, made in only one
worksheet, so that it can be visible on all worksheets (like a floating
window), when i navegate through them? This way, i will see the title and
buttons avaiable in that header/window on all worksheets i have, without
having to copy the same header and objects to all worksheets (what is
impossible, due to the amount of memory the images and buttons in the header
would use). I don't want to print this worksheets with this header, I just
want to "see" (and use) this header on top of all worksheets in this
workbook. Then, if i made any change on that header (what happens
frequently), i would do this only once, and it would be avaiable to the
entire workbook.
My main objective with this header is navigation between worksheets.
What i really want is a floating window for navigation. I tryed this once
with a userform, floating above my worksheets, but the problem was to resize
it to fit the diferent screen resolutions. When i did this some objects and
images became weird. I'd like to do this using a floating worksheet, like a
new window with the AlwaysOnTop property 'true'. I know there is no
AlwaysOnTop property for windows, but that's what best describes what I want
to do, as windows resize ok (no problems with images and other objects with
different ZOOMs).
I'm using Excel 2003 and Windows XP SP2.
Thanks. And, sorry for the poor english.
Glauco.