Missing toolbars

  • Thread starter Thread starter Help!
  • Start date Start date
H

Help!

I need some help on a fairly easy yet stupid question. My formtting
toolbar has gone missing and I have tried a number of things to get it
back. I have tried turnging it off and on and changing the resolution to
see if it was off the screen but no luck there either. Can anyone help
me?
 
A pet peeve of mine.....
Use a name other than "Help" or "anonymous"
Joe, Frank, Charlie, Demosthonese, anything will do (it doesn't even
have to be your real first name).

Have you tried
View/Toolbars
and checked "Formatting"

If there's something missing from that Toolbar, press "Reset" while you're
there.

John (my real name)

I need some help on a fairly easy yet stupid question. My formtting
toolbar has gone missing and I have tried a number of things to get it
back. I have tried turnging it off and on and changing the resolution to
see if it was off the screen but no luck there either. Can anyone help
me?
 
Sorry to offend you John! Entered my details in a rush yesterday and
didn't think. Didn't quite think someone would have that as a pet hate
though, maybe you should get out more...

Have tried all that but nothing, its just dropped off the face of the
earth. I will keep trying but thanks.

Sarah
 
You could try this:

Open excel
hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window

type this and hit enter:
application.CommandBars("Formatting").Enabled = true
then
application.CommandBars("Formatting").visible = true

Then back to excel to look.

If that didn't work, you could dump the current customized toolbar and start
from scratch.

If that appeals to you, then
close excel
windows start button|search/find
look for *.xlb (search in hidden folders for hidden files)

Rename all of them to *.xlbOLD

Restart excel and if it helped, then recustomize your toolbar, then go back and
delete all those *.xlbOLD files.

If it didn't help, then rename the *.xlbOLD back to *.xlb. (nothing lost but
time.)

And a hint so you won't have to rebuild them again. After you get your
customizations done, find that newest *.xlb and back it up to a nice backup
folder (and floppy???).

If you ever destroy your toolbar (or want to destroy it--it sometimes gets
bloated and causes problems), you can copy the backup and replace the "real"
one.
 
Sara,
Didn't quite think someone would have that as a pet hate
Click to expand...
I didn't say "hate" (that takes effort), I said "peeve" (minor annoyance).
Sorry to offend you John!
Click to expand...
I wasn't offended in the least. I just find it more congenial to reply to
a name as opposed to "HELP!" or "Anonymous".

Regardless, I did make an attempt to answer your question although
Dave's reply will probably be the one that cures your ills with the toolbar.
Entered my details in a rush yesterday and didn't think.
Click to expand...
Of what?? Your name??

Hope that you got your toolbar back with Dave's help.
He pretty much covered all the bases with his reply.

John


----- Sarah wrote: -----

Sorry to offend you John! Entered my details in a rush yesterday and
didn't think. Didn't quite think someone would have that as a pet hate
though, maybe you should get out more...

Have tried all that but nothing, its just dropped off the face of the
earth. I will keep trying but thanks.

Sarah
 
-----Original Message-----
You could try this:

Open excel
hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window

type this and hit enter:
application.CommandBars("Formatting").Enabled = true
then
application.CommandBars("Formatting").visible = true

Then back to excel to look.

If that didn't work, you could dump the current customized toolbar and start
from scratch.

If that appeals to you, then
close excel
windows start button|search/find
look for *.xlb (search in hidden folders for hidden files)

Rename all of them to *.xlbOLD

Restart excel and if it helped, then recustomize your toolbar, then go back and
delete all those *.xlbOLD files.

If it didn't help, then rename the *.xlbOLD back to *.xlb. (nothing lost but
time.)

And a hint so you won't have to rebuild them again. After you get your
customizations done, find that newest *.xlb and back it up to a nice backup
folder (and floppy???).

If you ever destroy your toolbar (or want to destroy it--it sometimes gets
bloated and causes problems), you can copy the backup and replace the "real"
one.




--

Dave Peterson
(e-mail address removed)
.
Click to expand...
 
Thanks for your help but still no luck.

-----Original Message-----
You could try this:

Open excel
hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window

type this and hit enter:
application.CommandBars("Formatting").Enabled = true
then
application.CommandBars("Formatting").visible = true

Then back to excel to look.

If that didn't work, you could dump the current customized toolbar and start
from scratch.

If that appeals to you, then
close excel
windows start button|search/find
look for *.xlb (search in hidden folders for hidden files)

Rename all of them to *.xlbOLD

Restart excel and if it helped, then recustomize your toolbar, then go back and
delete all those *.xlbOLD files.

If it didn't help, then rename the *.xlbOLD back to *.xlb. (nothing lost but
time.)

And a hint so you won't have to rebuild them again. After you get your
customizations done, find that newest *.xlb and back it up to a nice backup
folder (and floppy???).

If you ever destroy your toolbar (or want to destroy it--it sometimes gets
bloated and causes problems), you can copy the backup and replace the "real"
one.




--

Dave Peterson
(e-mail address removed)
.
Click to expand...
 
I'm surprised that deleting/renaming all the *.xlb files didn't help.

Are you sure you found the correct one?
 
Back
Top