Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Excel 2003 toolbars to Excel 2007
I am using Excel 2003 very intensely and have defined several toolbars with
many buttons that activate VBA routines that I have programmed through the last 15 (?) years. Now I am so unlucky that 'higher powers' soon will force me to migrate to Excel 2007. It means a lot to me to be able to export my VBA and toolbars/buttons to Excel 2007. Probably VBA modules are easily imported to Excel 2007, but I have been told that the concept of toolbars does not at all exist in Excel 2007. Is this true, and if it is what can I then do? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Excel 2003 toolbars to Excel 2007
just open workbook in excel 07 and toolbars should be all on Add-ins tab.
"Helge V. Larsen" wrote in message ... |I am using Excel 2003 very intensely and have defined several toolbars with | many buttons that activate VBA routines that I have programmed through the | last 15 (?) years. | | Now I am so unlucky that 'higher powers' soon will force me to migrate to | Excel 2007. It means a lot to me to be able to export my VBA and | toolbars/buttons to Excel 2007. Probably VBA modules are easily imported to | Excel 2007, but I have been told that the concept of toolbars does not at | all exist in Excel 2007. | | Is this true, and if it is what can I then do? | | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Excel 2003 toolbars to Excel 2007
Hi Helge
If you not like what you see in the Add-ins tab see http://www.rondebruin.nl/qat.htm Or create a nice ribbon http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Homey" <none wrote in message ... just open workbook in excel 07 and toolbars should be all on Add-ins tab. "Helge V. Larsen" wrote in message ... |I am using Excel 2003 very intensely and have defined several toolbars with | many buttons that activate VBA routines that I have programmed through the | last 15 (?) years. | | Now I am so unlucky that 'higher powers' soon will force me to migrate to | Excel 2007. It means a lot to me to be able to export my VBA and | toolbars/buttons to Excel 2007. Probably VBA modules are easily imported to | Excel 2007, but I have been told that the concept of toolbars does not at | all exist in Excel 2007. | | Is this true, and if it is what can I then do? | | |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Excel 2003 toolbars to Excel 2007
My VBA and toolbar buttons are not used in only one workbook. It is hundreds
of general utilities (small and large) that are used in all workbooks. The VBA is in "C:\Documents and Settings\hela\Application Data\Microsoft\Excel\XLSTART\Personal.xls" and the toolbar definition is in "C:\Documents and Settings\hela\Application Data\Microsoft\Excel\Excel11.xlb" (I think). In Excel 2007 I would really like to have access to these utilities by clicking a button or in some way that is as easy and quick as a button. __________________________________________________ ________________________ "Homey" <none wrote in message ... just open workbook in excel 07 and toolbars should be all on Add-ins tab. "Helge V. Larsen" wrote in message ... |I am using Excel 2003 very intensely and have defined several toolbars with | many buttons that activate VBA routines that I have programmed through the | last 15 (?) years. | | Now I am so unlucky that 'higher powers' soon will force me to migrate to | Excel 2007. It means a lot to me to be able to export my VBA and | toolbars/buttons to Excel 2007. Probably VBA modules are easily imported to | Excel 2007, but I have been told that the concept of toolbars does not at | all exist in Excel 2007. | | Is this true, and if it is what can I then do? | | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Excel 2003 toolbars to Excel 2007
try using QAT as per ron's link:
http://www.rondebruin.nl/qat.htm "Helge V. Larsen" wrote in message ... My VBA and toolbar buttons are not used in only one workbook. It is hundreds of general utilities (small and large) that are used in all workbooks. The VBA is in "C:\Documents and Settings\hela\Application Data\Microsoft\Excel\XLSTART\Personal.xls" and the toolbar definition is in "C:\Documents and Settings\hela\Application Data\Microsoft\Excel\Excel11.xlb" (I think). In Excel 2007 I would really like to have access to these utilities by clicking a button or in some way that is as easy and quick as a button. __________________________________________________ ________________________ "Homey" <none wrote in message ... just open workbook in excel 07 and toolbars should be all on Add-ins tab. "Helge V. Larsen" wrote in message ... |I am using Excel 2003 very intensely and have defined several toolbars with | many buttons that activate VBA routines that I have programmed through the | last 15 (?) years. | | Now I am so unlucky that 'higher powers' soon will force me to migrate to | Excel 2007. It means a lot to me to be able to export my VBA and | toolbars/buttons to Excel 2007. Probably VBA modules are easily imported to | Excel 2007, but I have been told that the concept of toolbars does not at | all exist in Excel 2007. | | Is this true, and if it is what can I then do? | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: Customizing Toolbars | Excel Discussion (Misc queries) | |||
Transition from Excel 2003 to 2007 (toolbars, etc.) | Excel Discussion (Misc queries) | |||
problems importing Excel 2007 table into SharePoint 2003 | Excel Discussion (Misc queries) | |||
Toolbars in Excel 2003 | Excel Discussion (Misc queries) |