format toolbar disappear


S

SpeeD

Hi

my format toolbar has disappeared. I can make it appear in the usual
manner... right-click-toolbars or view-tollbars.

How can i make it appear? VBA?

Thanks
SpeeD
 
Ad

Advertisements

D

Dave Peterson

Did you mean you can NOT make it appear?

Maybe you could try this macro:

Option Explicit
Sub testme()
With Application.CommandBars("Formatting")
.Visible = True
.Enabled = True
End With
End Sub
 
S

SpeeD

Hi Dave.

I rely can´t make it appear!!
Your code return´s me a Messege:

Automation error
Unspecified error

Im´completely in the dark with this one....
i´ve installed this morning an trial addin and it started this problem...

SpeeD
 
D

Dave Peterson

What version of excel are you using?

If it's xl2007, then there is no formatting toolbar.

If it's xl2003, I'm not sure why it doesn't work for you.

Maybe it's a language difference???

For me (xl2003 in USA English), my Formatting toolbar has an index of 4.

What do you see when you run this?

msgbox Application.CommandBars(4).name

If it looks like it would translate to Formatting, then you can use (4) or what
you see in that msgbox.

=======
If worse comes to worse, you can delete the file that holds the toolbar. Any
changes that you've made to customize the toolbar will have to be recreated,
though.

If you want to try:

Close excel
use windows search to look for *.xlb
Delete (or move) any that you find.

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files.

Then delete/move them.

=======
Then try to restart excel to test.
 
S

SpeeD

Hi Dave.

Your right. iv´ve tried the Msgbox command and it return "Formatting", but
ivé tried´the following and i can´t make it appear anyway!

Application.CommandBars(4).Visible = True
Application.CommandBars("Formatting").Visible = True

What shloud i do? if i erase the xlb how can i find another that is ok?

Thanks SpeeD
 
Ad

Advertisements

S

SpeeD

Hi Dave....

well, i´ve moved the .xlb and everything is alright! thanks a lot!
.... long time since i´ve made something in DOS... Those where the days....
or not!!

Thanks Dave!

SpeeD
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top