View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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