View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Robert McCurdy Robert McCurdy is offline
external usenet poster
 
Posts: 102
Default Change from 2K to XP and Excel.xlb toolbars

Do a Save as back to your new XLStart folder.

Close and reopen XL after a few minutes and see if your macros are pointing back to the right place.

If so then delete the old file in the other folder.

You may have to do this more than once, as other workbooks may still remember where their toolbars were created.
Always backup these two files (Personal.xls & Excel10.xlb), I'd also rename Personal to something else.


Regards Robert

"Ed" wrote in message ...
Thank you, Rob! Now I get to continue slogging through this maze of code
fixing all the errors that will crop up because of all the changes. But at
least I *have* my code!

Ed

"Rob Bovey" wrote in message
...
"Ed" wrote in message
...
IT just changed me from Office 2K and Windows 2K to Office and Windows

XP.
whoopie 8\ I moved my old Excel.xlb to my new Application
Data\Microsoft\Excel folder. But I can't bring up my custom toolbars.

All
my macros came over with my Personal.xls. Can I get my toolbars back?

Or
should I just go about rebuilding them?


Hi Ed,

Use the File/Open menu in Excel to open the Excel.xlb file as if it

were
a workbook and you should get back all your customized toolbars.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *







---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004