Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbars placing at excel 2007
I wanted to place a drawing toolbar,control toolbar,form toolbar in my
workbook in excel 2007. Like i was doing in excel 2003 view|toolbars|drawing,controlbar,form. These toolbars remains stay in workbook upto when I close those toolbars manually. In this way I'm expecting to fix the toolbar (in excel 2007) in the default view eventhough if i select any menu. How to fix toolbars in excel-2007. Advanced Thanks, Vinod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbars placing at excel 2007
How to fix toolbars in excel-2007.
The only part of the Excel 2007 ribbon that is customizable through the user interface is the Quick Access Toolbar (QAT). You should be able to add the controls you want from the old toolbars to it. http://blogs.msdn.com/jensenh/archiv...12/750144.aspx -- Jim "Vinod" wrote in message ... |I wanted to place a drawing toolbar,control toolbar,form toolbar in my | workbook in excel 2007. Like i was doing in excel 2003 | view|toolbars|drawing,controlbar,form. | These toolbars remains stay in workbook upto when I close those toolbars | manually. In this way I'm expecting to fix the toolbar (in excel 2007) in the | default view eventhough if i select any menu. | | How to fix toolbars in excel-2007. | | Advanced Thanks, | Vinod |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbars placing at excel 2007
Thanks Jim,
Actually my requirement is, I had a workbook which contains 3rd party toolbar(4 buttons). when I open this workbook in excel 2003 the toolbar is at fixed place (able to view all buttons). Again I opened the same workbook in excel 2007 but I'm not able to view the 3rd party toolbar by default. for this I'm selecting Add-In menu then only I'm able to view the 3rd party toolbar (able to view 4 buttons). Later if I select any other ribbon then the 3rd party toolbar is disappering. So, is there any chance to place toolbars in fixed place in excel-2007. Advanced Thanks, Vinod "Jim Rech" wrote: How to fix toolbars in excel-2007. The only part of the Excel 2007 ribbon that is customizable through the user interface is the Quick Access Toolbar (QAT). You should be able to add the controls you want from the old toolbars to it. http://blogs.msdn.com/jensenh/archiv...12/750144.aspx -- Jim "Vinod" wrote in message ... |I wanted to place a drawing toolbar,control toolbar,form toolbar in my | workbook in excel 2007. Like i was doing in excel 2003 | view|toolbars|drawing,controlbar,form. | These toolbars remains stay in workbook upto when I close those toolbars | manually. In this way I'm expecting to fix the toolbar (in excel 2007) in the | default view eventhough if i select any menu. | | How to fix toolbars in excel-2007. | | Advanced Thanks, | Vinod |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbars placing at excel 2007
What you're seeing is the expected Excel 2007 behavior. All pre-2007
add-ins, etc., that modify existing or create their own toolbars and menus see those changes shifted to the Add-ins tab of the ribbon. And that tab is not always visible so the add-ins buttons are not always visible. You're not the first person to find this design less than desirable. The only thing you can do to make this situation slightly better is to customize the QAT. One thing you can do is add "Menu Commands" and/or "Custom Toolbars" to it. Then ALL the commands on the Add-ins tab will be 2 clicks away, clicks that do not change the active ribbon tab. You can also assign macros to buttons added the QAT. So you could assign buttons to specific macros in the add-in I would think (if they are accessible). If the add-in were rewritten for Excel 2007 it could modify the ribbon and add its commands to existing or new ribbon tabs. It could even add its commands to all the tabs so its command would always be visible. Space is limited so that might not be practical. -- Jim "Vinod" wrote in message ... | Thanks Jim, | | Actually my requirement is, | I had a workbook which contains 3rd party toolbar(4 buttons). when I open | this workbook in excel 2003 the toolbar is at fixed place (able to view all | buttons). Again I opened the same workbook in excel 2007 but I'm not able to | view the 3rd party toolbar by default. for this I'm selecting Add-In menu | then only I'm able to view the 3rd party toolbar (able to view 4 buttons). | Later if I select any other ribbon then the 3rd party toolbar is disappering. | | So, is there any chance to place toolbars in fixed place in excel-2007. | | Advanced Thanks, | Vinod | | | "Jim Rech" wrote: | | How to fix toolbars in excel-2007. | | The only part of the Excel 2007 ribbon that is customizable through the user | interface is the Quick Access Toolbar (QAT). You should be able to add the | controls you want from the old toolbars to it. | | http://blogs.msdn.com/jensenh/archiv...12/750144.aspx | | -- | Jim | "Vinod" wrote in message | ... | |I wanted to place a drawing toolbar,control toolbar,form toolbar in my | | workbook in excel 2007. Like i was doing in excel 2003 | | view|toolbars|drawing,controlbar,form. | | These toolbars remains stay in workbook upto when I close those toolbars | | manually. In this way I'm expecting to fix the toolbar (in excel 2007) in | the | | default view eventhough if i select any menu. | | | | How to fix toolbars in excel-2007. | | | | Advanced Thanks, | | Vinod | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I control the order of Custom Toolbars appearing in the Add-Ins Tab of Excel 2007 | Excel Discussion (Misc queries) | |||
How do I put data in excel in placing order? eg first, second, th. | Excel Discussion (Misc queries) | |||
Change menu's and toolbars in 2007 | New Users to Excel | |||
Custom Toolbars (Ribbons?) for Excel 2007 | Excel Discussion (Misc queries) | |||
Modify Custom Toolbars in Excel 2007 | Excel Discussion (Misc queries) |