Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disable a taskbar
How do I disable the "Reviewing" taskbar in excel so it does not appear every
time I open a document? |
#2
|
|||
|
|||
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
|
|||
|
|||
....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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Query Refresh warning dialog box in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I set up a macro to turn on Windows in Taskbar in Excel 200 | Excel Discussion (Misc queries) | |||
How can I see multiple workbooks in the taskbar? Tried the Window. | Excel Discussion (Misc queries) | |||
Disable Adding & Deleting Rows/Columns | Excel Discussion (Misc queries) | |||
Disable menu selection | Excel Discussion (Misc queries) |