Importing Excel 2003 toolbars to Excel 2007

H

Helge V. Larsen

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?
 
H

Homey

just open workbook in excel 07 and toolbars should be all on Add-ins tab.


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?
|
|
 
H

Helge V. Larsen

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.
__________________________________________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top