View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Homey Homey is offline
external usenet poster
 
Posts: 143
Default 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?
|
|