#1   Report Post  
steve
 
Posts: n/a
Default Disable a taskbar

How do I disable the "Reviewing" taskbar in excel so it does not appear every
time I open a document?
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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.

--
Jim Rech

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

"steve" wrote in message
...
| How do I disable the "Reviewing" taskbar in excel so it does not appear
every
| time I open a document?


  #3   Report Post  
JR
 
Posts: n/a
Default

....go to "View", "Toolbars", then un-check "Reviewing". This applies to the
application and not a specific file.

"steve" wrote:

How do I disable the "Reviewing" taskbar in excel so it does not appear every
time I open a document?

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
Disable Query Refresh warning dialog box in Excel 2003 Jeff Koons Excel Discussion (Misc queries) 2 December 1st 05 04:08 PM
How do I set up a macro to turn on Windows in Taskbar in Excel 200 David Lee - NZ Excel Discussion (Misc queries) 2 May 13th 05 12:56 PM
How can I see multiple workbooks in the taskbar? Tried the Window. marg709 Excel Discussion (Misc queries) 0 March 23rd 05 09:53 PM
Disable Adding & Deleting Rows/Columns Playa Excel Discussion (Misc queries) 1 February 3rd 05 03:42 PM
Disable menu selection andy Excel Discussion (Misc queries) 3 December 10th 04 10:46 PM


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