Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 29th 08, 05:26 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 1
Default How do I stop a toolbar that always turns on when I open Excel?

Every time I open Excel XP the Reviewing toolbar automatically opens as well.
How do I prevent this from happening?

  #2   Report Post  
Old September 29th 08, 11:53 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default How do I stop a toolbar that always turns on when I open Excel?

A recent posting from Jim Rech addresses this.


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

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.

Gord adds this part........................

One other way that makes it happen is when you open via hyperlink.

Resume Jim post...............................

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.

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 Mon, 29 Sep 2008 09:26:01 -0700, Purge Thunder <Purge
wrote:

Every time I open Excel XP the Reviewing toolbar automatically opens as well.
How do I prevent this from happening?




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
Stop Recording ToolBar dissappeared in my Excel WorkSheet? Aamir New Users to Excel 3 August 23rd 06 06:28 AM
When I open Excel, workbooks open automatically. How can I stop t Rhealbird Excel Discussion (Misc queries) 2 February 23rd 06 11:08 AM
how to stop Reviewing toolbar from opening when I open a file WFLD Excel Discussion (Misc queries) 2 March 24th 05 01:43 AM
How do I stop Excel from closing the open file each time I open a. Welsin Setting up and Configuration of Excel 3 January 9th 05 12:16 AM
How do I stop the Reviewing toolbar from showing up in Excel? RickKel Excel Discussion (Misc queries) 2 November 26th 04 06:37 PM


All times are GMT +1. The time now is 11:16 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017