The reviewing toolbar drives me crazy. Is there a way to keep it from
opening automatically in excel? I do not want to remove it completely as I
do use it occasionally, but I don't want it to open with all the shared
documents I open. I tried writing an Auto_Open macro, but it did not do the
trick. Although I am pretty computer savvy, I do not understand code, so a
made-for-dummies answer would be great. THANKS!

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.

You have to save the workbook after deleting the custom properties. I don't
know if there are issues deleting file properties in a shared file since I
neve use them.

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

--
Jim
"mmr_osu" wrote in message
...
| The reviewing toolbar drives me crazy. Is there a way to keep it from
| opening automatically in excel? I do not want to remove it completely as
I
| do use it occasionally, but I don't want it to open with all the shared
| documents I open. I tried writing an Auto_Open macro, but it did not do
the
| trick. Although I am pretty computer savvy, I do not understand code, so
a
| made-for-dummies answer would be great. THANKS!

I do appreciate your respnse and advice. I made a new macro with a new name
(KillReviewingCustProps) and plugged what you wrote in. It didn't seem to
make a difference, but I am often opening documents just to read them and
hardly ever save them myself. So there is no way to keep it from appearing
in all documents? You have to run this in every spreadsheet that you open
and save the spreadsheet? I guess this wouldn't help me out then...?

I recorded a macro that only turned the toolbar off. Is there a way to run
it every time excel starts? I couldn't quite figure that part out from the
excel help file, but whenever I hit it as a button, it does make it go away.
Not really that much easier than right clicking and deselecting it, but far
less annoying! :o)

Thanks Jim!

Miranda


"Jim Rech" wrote:

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.

You have to save the workbook after deleting the custom properties. I don't
know if there are issues deleting file properties in a shared file since I
neve use them.

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

--
Jim
"mmr_osu" wrote in message
...
| The reviewing toolbar drives me crazy. Is there a way to keep it from
| opening automatically in excel? I do not want to remove it completely as
I
| do use it occasionally, but I don't want it to open with all the shared
| documents I open. I tried writing an Auto_Open macro, but it did not do
the
| trick. Although I am pretty computer savvy, I do not understand code, so
a
| made-for-dummies answer would be great. THANKS!

Excel always displays the Reviewing Toolbar when a workbook has the file
properties I mentioned. There is no way to turn this "feature" off, as far
as I know. You're right, my macro is only useful if your save the workbook
so that the next time you open it you don't get the toolbar.

--
Jim
"mmr_osu" wrote in message
...
|I do appreciate your respnse and advice. I made a new macro with a new
name
| (KillReviewingCustProps) and plugged what you wrote in. It didn't seem to
| make a difference, but I am often opening documents just to read them and
| hardly ever save them myself. So there is no way to keep it from
appearing
| in all documents? You have to run this in every spreadsheet that you open
| and save the spreadsheet? I guess this wouldn't help me out then...?
|
| I recorded a macro that only turned the toolbar off. Is there a way to
run
| it every time excel starts? I couldn't quite figure that part out from
the
| excel help file, but whenever I hit it as a button, it does make it go
away.
| Not really that much easier than right clicking and deselecting it, but
far
| less annoying! :o)
|
| Thanks Jim!
|
| Miranda
|
|
| "Jim Rech" wrote:
|
| 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.
|
| You have to save the workbook after deleting the custom properties. I
don't
| know if there are issues deleting file properties in a shared file since
I
| neve use them.
|
| 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
|
| --
| Jim
| "mmr_osu" wrote in message
| ...
| | The reviewing toolbar drives me crazy. Is there a way to keep it from
| | opening automatically in excel? I do not want to remove it completely
as
| I
| | do use it occasionally, but I don't want it to open with all the
shared
| | documents I open. I tried writing an Auto_Open macro, but it did not
do
| the
| | trick. Although I am pretty computer savvy, I do not understand code,
so
| a
| | made-for-dummies answer would be great. THANKS!
|
|
|