Freeze Panes Twice?

B

beeawwb

Good afternoon all,

Does anybody know if it is possible to use Multiple freeze panes?
have a 'Menu' frozen on top of the screen, but I want to add anothe
menu to the bottom of the screen as well.

Any ideas how I might go about this?

Thanks for your help,

-Bo
 
F

firefytr

hi Bob,

i don't think you can. you could always start a new 'window' of th
excel session (Window -> New Window) or split the window (Window -
Split).

ht
 
B

beeawwb

I dont think either of those will work. What I'm trying to do is this.



_________________
PRINT | ADD | RESET |
_____|____|______|
List List List
List List List
List List List
List List List
List List List
List List List
List List List
_________________
ABCDEFGHIJKLMN
OPQRSTUVWXYZ
_________________


So that users can quickly jump to a specific letter of the alphabet b
1 menu, and use my fax buttons in the other menu.

The reason I don't put the ABCD Etc buttons in the top menu, is becaus
that "Freeze Pane" has the labels that need to remain on top of th
screen, and I think it would look cluttered to add 26 more buttons t
that area.

Any thoughts?

-Bo
 
B

beeawwb

Actually, this has been put aside in relation to a new problem.
finished transcribing the list, and then created a copy to sor
alphabetically. Had 1 sheet sorted alpha, 1 by box (my original list
hidden).

Saved the sheet, re-opened... Excel crashes. o_O

-
 
D

Dave Peterson

If you try opening the workbook when you start excel in safe mode, does it
crash?

close excel
windows start button
Excel /safe

I'm guessing that the crash could be caused by excel, caused by the workbook, or
caused by something else completely????

By opening in safe mode, you're eliminating a lot of things that start up when
excel starts--you're testing the workbook itself.

If it doesn't work in excel's safe mode:

You might be able to recover your workbook by using another program--both
xl2002 and OpenOffice have better reputations for opening files that
earlier versions of excel couldn't.

(http://www.openoffice.org, a 60-65 meg download or a CD)

If it works ok in safe mode, then maybe it's something that loads when excel
starts. I'd start with the file that contains the customized toolbars.

close excel
windows start button|find/search for *.xlb

rename them to *.xlbOLD
and try it again. If it worked ok, then dump those *.xlbOLD files and recreate
your toolbars at your leisure.

If it didn't help, rename them back to *.xlb and see if there's something else
that's causing the trouble.

You can use some techniques that Chip Pearson shares on his web site:
http://www.cpearson.com/excel/StartupErrors.htm

Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)

Then one by one, you'll add one back and restart excel to see if that caused the
problem.

====
If that doesn't work, it could be lots of stuff (complete guesses follow).

I'd try reinstalling excel, changing the printer driver,...

=====
But my money is on the workbook itself (maybe just one worksheet) or the *.xlb
file. (But it could be lots of stuff!)
 
B

beeawwb

Renamed *.xlb files to Xlbold, and started in safe mode. Neither worked
Interstingly enough though, CPU usage jumped to 99% (Task manager) whe
I opened the workbook this time, which it hasn't done before.

Also interesting, I took my backup copy (there's no WAY I'd wor
without making a backup) and did the EXACT same steps I did to make th
alpha...and now it works. But the old book still doesn't. It's reall
weird. But, I have a working copy now, so I'm not that worried.

-
 
L

Lady Layla

One other thing to try -- delete all files in your Temp directories. HAve had
files crash and been able to recover them after clearing those directories


: Renamed *.xlb files to Xlbold, and started in safe mode. Neither worked.
: Interstingly enough though, CPU usage jumped to 99% (Task manager) when
: I opened the workbook this time, which it hasn't done before.
:
: Also interesting, I took my backup copy (there's no WAY I'd work
: without making a backup) and did the EXACT same steps I did to make the
: alpha...and now it works. But the old book still doesn't. It's really
: weird. But, I have a working copy now, so I'm not that worried.
:
: -B
:
:
: ---
:
:
 
D

Dave Peterson

Glad you found the answer.

Maybe the workbook/worksheet was on the verge of being corrupt. Recreating the
worksheet brought things back to normal.
 
Top