Toolbar Setting

[Michelle]

Each time I open an Excel attachment from my email
(Outlook), it automatically changes my toolbar setting to
include “Reviewing”. I have tried to remove this several
times, but it keeps popping up. Is there a way to make
sure that reviewing never shows up on my toolbar when I
open a file from email?

Thanks.

M

 

[Lady Layla]

One way is to not open the file directly from outlook. Save file to HD, then
open from within Excel program



: Each time I open an Excel attachment from my email
: (Outlook), it automatically changes my toolbar setting to
: include “Reviewing”. I have tried to remove this several
: times, but it keeps popping up. Is there a way to make
: sure that reviewing never shows up on my toolbar when I
: open a file from email?
:
: Thanks.
:
: M

 

[Jim Rech]

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

| Each time I open an Excel attachment from my email
| (Outlook), it automatically changes my toolbar setting to
| include “Reviewing”. I have tried to remove this several
| times, but it keeps popping up. Is there a way to make
| sure that reviewing never shows up on my toolbar when I
| open a file from email?
|
| Thanks.
|
| M