Does anyone know of a way to Save the Toolbar settings to ONLY show the
ones I want? It's driving me crazy!
Thanks for any suggestions!
TinyDancer
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
You can kill the added file properties manually or run the below macro to do
it. This macro is in my Personal and attached to a toolbar button because I
feel the same way as you about this toolbar.
If the toolbar pops up every time you start Excel then perhaps there is a
workbook in your XLSTART folder that is the cause.
--
Jim Rech
Excel MVP
Sub KillReviewingCustProps()
Dim x As DocumentProperties
Dim Counter As Integer
Set x = ActiveWorkbook.CustomDocumentProperties
For Counter = x.Count To 1 Step -1
If Left(x.Item(Counter).Name, 1) = "_" Then _
x.Item(Counter).Delete
Next
CommandBars("Reviewing").Visible = False
End Sub