Thread: toolbars
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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.