How to turn off automatic toolbar appearance

G

Gryzor

Well, the subject says it all. For instance, when I open an excel sheet attached to an email, the Reviewing toolbar appears. Or, when I click on a custom-made button linked to a file, the Web toolbar shows up. Is there any way to prevent that

Kind regard
Th.P.
 
J

Jim Rech

Re the Reviewing toolbar, from an earlier post:

The Reviewing toolbar in Excel pops up whenever you open a workbook that has
been emailed from within Excel "for review". There may be other ways to
make this happen too. If you do a File, Properties you'll see the custom
file properties that have been added that triggers this.

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.

--
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
 
G

Gryzor

Hello Jim

Thanks for the reply; really useful macro... Wish Office had an option to ignore certain attributes..

Kind regard
Th
 
Top