Standard/Formating Toolbar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My standard and formating toolbar is gone. I went to view,toolbars to select
it and its not an option there anymore. What happened? How can I get the
standart and formating toolbar back?
 
Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to get to the immediate window
type this and hit enter:
application.CommandBars("standard").Enabled = true

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

Then back to excel. If you don't see the toolbars, then tools|Customize and
select them.
 

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

Similar Threads

how to turn off standard toolbar, formatting... Microsoft Excel 20 4
Toolbar is gone 4
Changing format of number icon in Excel 2007 toolbar 1
standard toolbar does not show up when starting up 2
How do I find more buttons on formating toolbar? 1
Standard Toolbar 3
Print Preview is gone! 2
Toolbar buttons to hide/unhide sheets 8

Back
Top