Missing toolbar in Excel 97

D

Denise

Hello

I need some help restoring a missing toolbar in Excel 97. One of my users
accidentally shifted the Standard toolbar so that it was floating. When
they tried to return it to its dock, the toolbar 'flew off the top of the
screen'. They are now not able to get the toolbar back.

The Standard toolbar is ticked in View/Toolbars, but the user cannot find
it, not even the bottom line of the toolbar is visible at the top of the
screen for them to grab.

I tried the following code to get the toolbar back, based on Excel 2002,
which I am using:-

Sub Test()
Application.CommandBars("Standard").Position = msoBarTop
End Sub

This worked on my machine, but not on the user's. The user is remote, so I
can't actually access their machine personally. I talked them through
inputting and running the code. It ran, but did not restore the toolbar.
We also tried msoBarFloating, and msoBarBottom, for good measure.

Is there anything else we could try? I'd appreciate any help on this.

Thanks

Denise Crawley
 
D

Dave Peterson

One way is to clean up all the toolbars and let excel put them back to the
defaults.

Have the user close excel
then windows start button|search
Search for all *.xlb files (in hidden folders, too)

Rename all the *.xlb files to *.xlbOLD

Start excel and see if it worked.

If it did, delete those *.xlbOLD files.

The user will have to reapply any changes made to any toolbar with this
technique.
 
N

NlCO

First enter to excel ;)
Press Alt
Pres CTRL+Tab until it desapears (should be in the standarr bar)
Once there Press Left Arrow
Then down arrow
Then left arrow 2 times
Press Enter.

Now you are moving the bar, try to get it back.

If not, you can always change the screen resolution into a smaller one
bring back the bar and then enlarge it again.


Saludos

NiCO
 
D

Denise

Hi Dave

Thanks for youe quick response. I'll get my user to try that, and
hopefully it'll solve the problem.

Thanks again

Denise
 
D

Denise

Hi Nico

Thanks for your reply. Does this work in Excel 2002? I'm trying it, but
it doesn't seem to be doing anything, except move me round the cells. Am I
missing something?!

Thanks

Denise
 
D

Dave Peterson

I think you may have missed pressing the Alt key first.

If you press that first, you'll be taken to the first icon of the first
toolbar. (File on the worksheet menu.)

Ctrl-Tab will move between toolbars--selecting the first icon in that toolbar.

Once you see that no visible toolbars have the first icon selected, NICO is
figuring that you're on the hidden toolbar.

Pressing the left arrow once, chooses the customize down arrow (either in the
title bar of a floating toolbar or the right icon of a docked toolbar).

Then hitting the down arrow is the same as clicking on that customize arrow.

Then hitting the down arrow moves to the "move Size" option.

Hitting the left arrow twice moves to the Move icon.

Now you should be able to use the arrow keys (or the mouse) to relocate that
toolbar.

Hit enter when you position the toolbar where it's visible.

Since you're doing this blind, you have to be careful with your keystrokes.
(Two days later, I got it to work <vbg>.)
 
D

Denise

I think you may have missed pressing the Alt key first.

If you press that first, you'll be taken to the first icon of the first
toolbar. (File on the worksheet menu.)

Ctrl-Tab will move between toolbars--selecting the first icon in that toolbar.

Once you see that no visible toolbars have the first icon selected, NICO is
figuring that you're on the hidden toolbar.

Pressing the left arrow once, chooses the customize down arrow (either in the
title bar of a floating toolbar or the right icon of a docked toolbar).

Then hitting the down arrow is the same as clicking on that customize arrow.

Then hitting the down arrow moves to the "move Size" option.

Hitting the left arrow twice moves to the Move icon.

Now you should be able to use the arrow keys (or the mouse) to relocate that
toolbar.

Hit enter when you position the toolbar where it's visible.

Since you're doing this blind, you have to be careful with your keystrokes.
(Two days later, I got it to work <vbg>.)
Click to expand...
Aaaaahhhhh. The LEFT Alt key! Right Alt did nothing, and that's the one I
was pressing. I'm so embarrassed *blush*

Thanks for your help, guys. I'll get my user to give it a try.

Denise

 
Top