Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Menus and Toolbars
I customize my menus and toolbar buttons for ease of use in all the Microsoft
products that I use. The problwem is that wehen I open a spreadsheet, document or presentation that someone has emailed to me, my menus and toolbars take on some characteristics of the sender (e.g. adding a 'Reviewing Toolbar' (which I hate); changing my spreadseehts from R1C1 to A1 orientations; redirceting my default menu to open (in Powerpoint Only), etc.). How do I stop this from happening - it is EXTREMELY ANNOYING. I am using Office 2002. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Menus and Toolbars
I don't use PPT or MSWord or Access to help with questions there, but...
#1. Reference style: Excel will pick up the reference style (A1 or R1C1) from the first workbook that it opens in that session. So if the first workbook you open is in A1 reference style, then you'll be ok. Maybe you can open one of your own workbooks first???? #2. 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....................... Needy Ned wrote: I customize my menus and toolbar buttons for ease of use in all the Microsoft products that I use. The problwem is that wehen I open a spreadsheet, document or presentation that someone has emailed to me, my menus and toolbars take on some characteristics of the sender (e.g. adding a 'Reviewing Toolbar' (which I hate); changing my spreadseehts from R1C1 to A1 orientations; redirceting my default menu to open (in Powerpoint Only), etc.). How do I stop this from happening - it is EXTREMELY ANNOYING. I am using Office 2002. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot unhide toolbars/menus | Excel Discussion (Misc queries) | |||
Custom Menus and Toolbars | Excel Discussion (Misc queries) | |||
How can I share custom Toolbars and Menus | Excel Discussion (Misc queries) | |||
Excel Menus/Toolbars missing | Excel Discussion (Misc queries) | |||
Missing menus and toolbars | Excel Discussion (Misc queries) |