ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Standard/Formating Toolbar (https://www.excelbanter.com/excel-discussion-misc-queries/67407-standard-formating-toolbar.html)

jkesl

Standard/Formating Toolbar
 
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?

Dave Peterson

Standard/Formating Toolbar
 
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.

jkesl wrote:

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?


--

Dave Peterson


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com