Excel 2007

[MikeH2]

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.

 

[Jon Peltier]

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

 

[Jim Rech]

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

 

[Jon Peltier]

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

- Jon