toolbars

[Guest]

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.

 

[Norman Jones]

Hi Robert.

See Jim Rech's suggestion at:

http://tinyurl.com/bvs6y

 

[Guest]

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.

 

[Bob Phillips]

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)