Missing toolbar in Excel 97

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

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.

Denise wrote:
>
> 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

--

Dave Peterson

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

On Thu, 01 Sep 2005 07:11:22 -0500, Dave Peterson wrote:

> 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.
>
> Denise wrote:
>>
>> 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

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

On Thu, 1 Sep 2005 07:21:37 -0500, NlCO wrote:

> 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

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>.)

Denise wrote:
>
> 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
>
> On Thu, 1 Sep 2005 07:21:37 -0500, NlCO wrote:
>
> > 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

--

Dave Peterson

On Fri, 02 Sep 2005 07:35:53 -0500, Dave Peterson wrote:

> 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>.)
>
> Denise wrote:
>>
>> 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
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


>>
>> On Thu, 1 Sep 2005 07:21:37 -0500, NlCO wrote:
>>
>>> 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

FYI only...

Both Alt keys worked ok for me.

Denise wrote:
<<snipped>>
> 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
>

--

Dave Peterson