Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbars
I was recently updated to the latest version of MS Office. When I open an
excel file the "Reviewing" toolbar is at the top. I remove it but I cannot keep it from reappearing at some later time when opening an other excel file. How do I get it permanently removed from the tool bar at the top so that it will no longer appear when I open an excel file in the future. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbars
Hi Robert.
See Jim Rech's suggestion at: http://tinyurl.com/bvs6y --- Regards, Norman "robert" wrote in message ... I was recently updated to the latest version of MS Office. When I open an excel file the "Reviewing" toolbar is at the top. I remove it but I cannot keep it from reappearing at some later time when opening an other excel file. How do I get it permanently removed from the tool bar at the top so that it will no longer appear when I open an excel file in the future. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbars
Hi Norman
Thanks for the response. I was hoping for a more global solution. Microsoft needs to provide ways to turn off some of their enhancements that people don't want. Some of their enhancements are irritating. "Norman Jones" wrote: Hi Robert. See Jim Rech's suggestion at: http://tinyurl.com/bvs6y --- Regards, Norman "robert" wrote in message ... I was recently updated to the latest version of MS Office. When I open an excel file the "Reviewing" toolbar is at the top. I remove it but I cannot keep it from reappearing at some later time when opening an other excel file. How do I get it permanently removed from the tool bar at the top so that it will no longer appear when I open an excel file in the future. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbars
You could write an application event and have a workbook open that
automatically turns it off, like this Public WithEvents App As Application Private Sub App_WorkbookOpen(ByVal Wb As Workbook) Dim oProp As DocumentProperties Dim Counter As Integer Set oProp = ActiveWorkbook.CustomDocumentProperties For Counter = oProp.Count To 1 Step -1 If Left(oProp.Item(Counter).Name, 1) = "_" Then _ oProp.Item(Counter).Delete Next CommandBars("Reviewing").Visible = False End Sub Private Sub Workbook_Open() Set App = Application End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips (remove nothere from email address if mailing direct) "robert" wrote in message ... Hi Norman Thanks for the response. I was hoping for a more global solution. Microsoft needs to provide ways to turn off some of their enhancements that people don't want. Some of their enhancements are irritating. "Norman Jones" wrote: Hi Robert. See Jim Rech's suggestion at: http://tinyurl.com/bvs6y --- Regards, Norman "robert" wrote in message ... I was recently updated to the latest version of MS Office. When I open an excel file the "Reviewing" toolbar is at the top. I remove it but I cannot keep it from reappearing at some later time when opening an other excel file. How do I get it permanently removed from the tool bar at the top so that it will no longer appear when I open an excel file in the future. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide toolbars, menu bar, etc | Excel Discussion (Misc queries) | |||
Toolbars will not stay where I put them | Excel Discussion (Misc queries) | |||
ToolBars | New Users to Excel | |||
Customizing ToolBars | Excel Discussion (Misc queries) | |||
Cant add an icon to toolbars | Excel Discussion (Misc queries) |