Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for any help.
Sometimes when I open an Excel file, even though I didn't have the review tool bar turned on, it shows up. I want to maximize view space as much as possible, and I never use the review tool bar. So what I do is Tooltool barand click off review tool bar, but I do that a bunch of the times throughout the day. Is there some way I can tell Excel never to show it? Maybe code if necessary? Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ian
A 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 Mon, 9 Apr 2007 08:12:03 -0700, Ian Elliott wrote: Thanks for any help. Sometimes when I open an Excel file, even though I didn't have the review tool bar turned on, it shows up. I want to maximize view space as much as possible, and I never use the review tool bar. So what I do is Tooltool barand click off review tool bar, but I do that a bunch of the times throughout the day. Is there some way I can tell Excel never to show it? Maybe code if necessary? Thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Gord!
"Gord Dibben" wrote: Ian A 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 Mon, 9 Apr 2007 08:12:03 -0700, Ian Elliott wrote: Thanks for any help. Sometimes when I open an Excel file, even though I didn't have the review tool bar turned on, it shows up. I want to maximize view space as much as possible, and I never use the review tool bar. So what I do is Tooltool barand click off review tool bar, but I do that a bunch of the times throughout the day. Is there some way I can tell Excel never to show it? Maybe code if necessary? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I change macro relative reference? no stop recording tool | Excel Discussion (Misc queries) | |||
How can I stop the Web and Review toolbar opening up randomly? | Excel Discussion (Misc queries) | |||
to stop zero from showing on graph | Charts and Charting in Excel | |||
Review Tool bar | Excel Discussion (Misc queries) | |||
review tool bar appears without asking for it | Excel Discussion (Misc queries) |