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