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.