![]() |
Disable a taskbar
How do I disable the "Reviewing" taskbar in excel so it does not appear every
time I open a document? |
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? |
....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? |
All times are GMT +1. The time now is 08:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com