Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Certain workbooks turn ON Reviewing Toolbar automatically
I receive financial data from the bookkeeper as an Excel workbook. Openning
these workbooks turns ON the Reviewing Toolbar. It then remains on, and defaults on at next Excel start unless I remember to turn it OFF. This is annoying as there are no Reviewers changes or comments on these workbooks. Can this behavior be disabled? I know I can Re-SAVE the file with the toolbar turned off, but the next month's file will still turn on the Reviewing toolbar. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Certain workbooks turn ON Reviewing Toolbar automatically
First open Excel and, then from Excel, open the workbook.
-- Gary''s Student - gsnu200776 "Ron_R" wrote: I receive financial data from the bookkeeper as an Excel workbook. Openning these workbooks turns ON the Reviewing Toolbar. It then remains on, and defaults on at next Excel start unless I remember to turn it OFF. This is annoying as there are no Reviewers changes or comments on these workbooks. Can this behavior be disabled? I know I can Re-SAVE the file with the toolbar turned off, but the next month's file will still turn on the Reviewing toolbar. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Certain workbooks turn ON Reviewing Toolbar automatically
Gord Dibben posted this (originally from Jim Rech):
A recent posting from Jim Rech addresses this. Jim post.................. If the workbook is sent as an attachment to Outlook then File, Properties are automatically added which will make the Reviewing toolbar appear when the workbook is opened in Excel. I don't know of a way to stop this. However, once you open the workbook in Excel you can remove these properties and save the workbook. After that it will no longer cause the reviewing toolbar to appear. Here's an old message on that: -------------- 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. This macro is in my Personal and attached to a toolbar button because I feel the same way as you about this toolbar. -- Jim Rech Excel MVP 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 Ron_R wrote: I receive financial data from the bookkeeper as an Excel workbook. Openning these workbooks turns ON the Reviewing Toolbar. It then remains on, and defaults on at next Excel start unless I remember to turn it OFF. This is annoying as there are no Reviewers changes or comments on these workbooks. Can this behavior be disabled? I know I can Re-SAVE the file with the toolbar turned off, but the next month's file will still turn on the Reviewing toolbar. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off "Reviewing" toolbar that opens at eXcel start? | Setting up and Configuration of Excel | |||
Turn off Reviewing options at the application level | Excel Discussion (Misc queries) | |||
How to prevent "Reviewing" toolbar from "automatically" appearing? | Excel Discussion (Misc queries) | |||
reviewing toolbar always there... | Excel Discussion (Misc queries) | |||
How can I stop Reviewing Toolbar automatically appearing? | Setting up and Configuration of Excel |