Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i stop the reviewing toolbar from automatically loading?
I don't use this function and would like to stop this happening. I believe
there is a macro that does this. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i stop the reviewing toolbar from automatically loading?
In your personal.xls file, insert the following in the workbook code area:
Private Sub Workbook_Open() Application.CommandBars("Reviewing").Visible = False End Sub This will close the toolbar if it was accidentally left open. -- Gary''s Student - gsnu200802 "bj62" wrote: I don't use this function and would like to stop this happening. I believe there is a macro that does this. Can anyone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i stop the reviewing toolbar from automatically loading?
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.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 "bj62" wrote in message ... |I don't use this function and would like to stop this happening. I believe | there is a macro that does this. Can anyone help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i stop the reviewing toolbar from automatically loading?
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 Tue, 2 Sep 2008 01:37:01 -0700, bj62 wrote: I don't use this function and would like to stop this happening. I believe there is a macro that does this. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop reviewing bar from automatically appearing | Excel Discussion (Misc queries) | |||
how to stop Reviewing toolbar from opening when I open a file | Excel Discussion (Misc queries) | |||
How can I stop Reviewing Toolbar automatically appearing? | Setting up and Configuration of Excel | |||
Reviewing Toolbar - how to stop it from displaying | Excel Worksheet Functions | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |