Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JM JM is offline
external usenet poster
 
Posts: 37
Default Reviewing tool bar automaticaly popping up

When I open an excel file that has been e-mailed to me, the reviewing tool
bar pops up. Does anyone know how to stop this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Reviewing tool bar automaticaly popping up

Gord Dibben posted this (originally from Jim Rech):

A recent posting from Jim Rech addresses this.

Jim's 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.......................

JM wrote:

When I open an excel file that has been e-mailed to me, the reviewing tool
bar pops up. Does anyone know how to stop this?


--

Dave Peterson
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
Clipboard Keeps Popping Up Cincy Excel Discussion (Misc queries) 1 July 5th 06 10:14 PM
Removing Reviewing Tool Bar ONCPHY Setting up and Configuration of Excel 2 March 13th 06 09:24 PM
Removing Reviewing Tool Bar ONCPHY Excel Worksheet Functions 1 March 13th 06 08:28 PM
Reviewing Tool Bar ONCPHY Excel Discussion (Misc queries) 0 March 13th 06 08:17 PM
how TO prevent reviewing toolbar from popping up when I open A wks CHIEF Excel Discussion (Misc queries) 3 January 23rd 06 07:07 PM


All times are GMT +1. The time now is 06:29 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"