Home |
Search |
Today's Posts |
#1
|
|||
|
|||
review toolbar reappears
I searched but did not find this in a topic - so sorry if it has been asked
and answered. I have a recurring issue where the Review Toolbar appears without me taking any action. I don't know why, it just does. I can't recreate a series of events that causes it. Not a big issue, but really annoying. Anyone have a solution? Thanks, Dave |
#2
|
|||
|
|||
If this appearing coincides with opening a file...
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. Sub KillReviewingCustProps() Dim x As DocumentProperties Dim Counter As Integer Set x = ActiveWorkbook.CustomDocumentP*roperties For Counter = x.Count To 1 Step -1 If Left(x.Item(Counter).Name, 1) = "_" Then _ x.Item(Counter).Delete Next CommandBars("Reviewing").Visib*le = False End Sub -- Jim "dave" wrote in message ... |I searched but did not find this in a topic - so sorry if it has been asked | and answered. | | I have a recurring issue where the Review Toolbar appears without me taking | any action. I don't know why, it just does. | | I can't recreate a series of events that causes it. | | Not a big issue, but really annoying. | | Anyone have a solution? | | Thanks, | | Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to prevent "Reviewing" toolbar from "automatically" appearing? | Excel Discussion (Misc queries) | |||
Is there a way to lock in the toolbar settings?? | Excel Discussion (Misc queries) | |||
"work items toolbar" | Excel Discussion (Misc queries) | |||
"Drawing" Toolbar is inactive | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |