Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jay
 
Posts: n/a
Default Reviewing Toolbar - how to stop it from displaying

I have Excel 2003 and I'm noticing that the Reviewing toolbar pops up every
time I open a workbook that I didn't create. Does anyone know how to turn
this feature off. If and when I want it, I'll turn the reviewing toolbar on.
I don't like it automatically poping up because it eats up some of my screen
real estate. Thanks.
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Jay

A recent posting from Jim Rech addresses this.

Jim post..................

If the workbook is sent as an attachment to Outlook then File, Properties
are automatically added which will make the Reviewing toolbar appear when
the workbook is opened in Excel. I don't know of a way to stop this.

However, once you open the workbook in Excel you can remove these properties
and save the workbook. After that it will no longer cause the reviewing
toolbar to appear. Here's an old message on that:

--------------

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

End Jim post.......................


Gord Dibben Excel MVP


On Tue, 30 Nov 2004 11:17:03 -0800, Jay wrote:

I have Excel 2003 and I'm noticing that the Reviewing toolbar pops up every
time I open a workbook that I didn't create. Does anyone know how to turn
this feature off. If and when I want it, I'll turn the reviewing toolbar on.
I don't like it automatically poping up because it eats up some of my screen
real estate. Thanks.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reviewing toolbar annoyance Steve Excel Discussion (Misc queries) 1 January 13th 05 09:57 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM
How can I stop Excel from displaying rounded numbers? Credit car. OldManP Excel Discussion (Misc queries) 3 December 8th 04 07:52 PM
Reviewing Toolbar (permanent fix) Jonathan Cooper Excel Discussion (Misc queries) 0 December 6th 04 07:45 PM
How do I stop the Reviewing toolbar from showing up in Excel? RickKel Excel Discussion (Misc queries) 2 November 26th 04 05:37 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"