Home |
Search |
Today's Posts |
#1
|
|||
|
|||
review tool bar appears without asking for it
In Excel, the reveiw toolbar keeps appearing at various times in my
spreadsheets. I never choose it as a toolbar and don't know why it keeps appearing. Any help would be great! |
#2
|
|||
|
|||
Shanny
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 On Fri, 18 Feb 2005 14:31:05 -0800, "Shanny2" wrote: In Excel, the reveiw toolbar keeps appearing at various times in my spreadsheets. I never choose it as a toolbar and don't know why it keeps appearing. Any help would be great! |
#3
|
|||
|
|||
Gord,
I added the macro to my personal.xls but the reviewing tool bar keep reappearing. You mentioned to you attach the macro to the toolbar. How do you do that? Thanks, Anat "Gord Dibben" wrote: Shanny 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 On Fri, 18 Feb 2005 14:31:05 -0800, "Shanny2" wrote: In Excel, the reveiw toolbar keeps appearing at various times in my spreadsheets. I never choose it as a toolbar and don't know why it keeps appearing. Any help would be great! |
#4
|
|||
|
|||
I'm not Gord, but you could read Jan Karel Pieterse's notes at:
http://google.com/groups?threadm=083...0a% 40phx.gbl Anat wrote: Gord, I added the macro to my personal.xls but the reviewing tool bar keep reappearing. You mentioned to you attach the macro to the toolbar. How do you do that? Thanks, Anat "Gord Dibben" wrote: Shanny 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 On Fri, 18 Feb 2005 14:31:05 -0800, "Shanny2" wrote: In Excel, the reveiw toolbar keeps appearing at various times in my spreadsheets. I never choose it as a toolbar and don't know why it keeps appearing. Any help would be great! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Tool Bar Gone | Excel Discussion (Misc queries) | |||
Using the Find tool in EXCEL | Excel Worksheet Functions | |||
Looking for Someone to review and make suggestions | Excel Discussion (Misc queries) | |||
Chart Label wraps on the same line. "Wavelenght [nm]" appears as. | Charts and Charting in Excel | |||
Employee review form | Excel Worksheet Functions |