Some coworkers now have Excel 2007. I copied my Personal.xls (Excel 2003)
file up on the network so I could "install" it on their pc's so they could
use some macros and have a menu addition on their menus to access these
macros easily but I am having trouble figuring out how to "install"
personal.xls on their pc's and making the menus available (even at the
"add-on" sub-menu). I am just using a .xls file for this.

The scope of UI changes has been changed in Excel 2007. In 2003 and earlier,
changes you made for one workbook were available for all. In 2007, a
workbook's UI customizations are only available when that workbook is
active. Since personal.xls is a hidden workbook, I guess you'll never see
these customizations.

In 2003, save your personal.xls as an add-in. An add-in's customizations are
available whenever the add-in is loaded (it need not be installed, just
opened from Windows Explorer or saved in XLSTART is enough).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MikeH2" wrote in message
...
Some coworkers now have Excel 2007. I copied my Personal.xls (Excel 2003)
file up on the network so I could "install" it on their pc's so they could
use some macros and have a menu addition on their menus to access these
macros easily but I am having trouble figuring out how to "install"
personal.xls on their pc's and making the menus available (even at the
"add-on" sub-menu). I am just using a .xls file for this.

Menu modifications made in Excel 2003 by attaching toolbars or using code
should appear on the Add-ins tab in Excel 2007. It doesn't matter whether
the workbook is active or visible.

--
Jim
"MikeH2" wrote in message
...
| Some coworkers now have Excel 2007. I copied my Personal.xls (Excel 2003)
| file up on the network so I could "install" it on their pc's so they could
| use some macros and have a menu addition on their menus to access these
| macros easily but I am having trouble figuring out how to "install"
| personal.xls on their pc's and making the menus available (even at the
| "add-on" sub-menu). I am just using a .xls file for this.

Next time I'll test it first. I assumed incorrectly that old style toolbar
customizations worked the same as new style ribbon hacks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Rech" wrote in message
...
Menu modifications made in Excel 2003 by attaching toolbars or using code
should appear on the Add-ins tab in Excel 2007. It doesn't matter whether
the workbook is active or visible.

--
Jim
"MikeH2" wrote in message
...
| Some coworkers now have Excel 2007. I copied my Personal.xls (Excel
2003)
| file up on the network so I could "install" it on their pc's so they
could
| use some macros and have a menu addition on their menus to access these
| macros easily but I am having trouble figuring out how to "install"
| personal.xls on their pc's and making the menus available (even at the
| "add-on" sub-menu). I am just using a .xls file for this.