Simulating HTML frames inside a Excel application
both Windows=Freeze and Split, work on a single sheet. To get multiple
views into a workbook, select the workbook window (floating windows) and do
Window=New. You can then organize the windows as you wish them to appear.
--
Regards,
Tom Ogilvy
"Matt Jensen" wrote in message
...
Howdy folks
I realise there is a few options available for my problem such as creating
my own menu bar or possibly using the 'camera' feature of Excel, but
before
I go with that option I wanted to see if my preferred option is a
possibility.
What I'd like to do would be to put a freeze frame in my worksheet below
an
area for my "Main Menu" (which may say be 5 standard rows deep), and for
the
section below the freeze frame to be able show any worksheet in the
workbook
(and I'd use the main menu options to navigate to these different
worksheets).
Can this be achieved? Can it be done by putting a 'split' in the worksheet
or something?
Hopefully my example explains well enough what I want to do
Thanks a lot for any help
Matt
|