2003 - 2007 custom macro and custom button restore.
Darn program says "......excel11.xlb" is not a valid add-in!!!!
"Jim Rech" wrote:
I clicked "Office Button", "Excell Options", "Add-ins" and did not find
any that looked like mine.
If the add-in is not known to Excel you should Browse to it after you click
the Go button.
--
Jim
"Scott Sornberger" wrote in
message ...
|I clicked "Office Button", "Excell Options", "Add-ins" and did not find any
| that looked like mine.
|
| I opened the Excel11.xlb. There was an Excel10.xlb also.
| I saved it as book1 in my user directory. I did see no change to the
above
| add-in list.
|
| I closed Excel and reopened Excel and went to find Excel12.xlb and it did
| not exist.
| Add-in list showed no change which seems right since I had on Excel12.mdb.
|
|
|
|
| "Jim Rech" wrote:
|
| For the most part Excel 2003 macros run in Excel 2007 just fine. If you
had
| modified your toolbars manually in Excel 2003 and those changes did not
| appear automatically in Excel 2007 on the Add-ins tab, I'd suggest
manually
| doing a File, Open of your Excel 2003 toolbar file (Excel11.xlb, usually
in
| C:\Documents and Settings\<user name\Application Data\Microsoft\Excel).
|
| That should load your Excel 2003 toolbars into the Add-ins tab and, when
you
| close Excel, your Excel12.xlb should be updates to retain those changes.
|
| --
| Jim
| "Scott Sornberger" wrote in
| message ...
| |i have a number of macros and custom buttons in Excel 2003 that I would
| like
| | to update to 2007. How may I accomplish this? Operating systiem is XP
| | Professional.
| | I did use the "Microsoft Office 2003 Save My Settings Wizard" before
the
| | company updated us to 2007.
|
|
|
|