Excel 2007

  • Thread starter Thread starter MikeH2
  • Start date Start date
M

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.
 
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
 
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.
 
Next time I'll test it first. I assumed incorrectly that old style toolbar
customizations worked the same as new style ribbon hacks.

- Jon
 
Back
Top