Help: Lost custom macros and won't load personal.xls

[Ed Jay]

Using Excel 2002 SP3 under XP-pro SP1.

I used a system cleaner and in the process I lost my custom toolbar
buttons with macros assigned. Additionally, when I launch Excel, it no
longer loads 'personal.xls,' contained in Excel/Start.

The buttons are easily replaced, but the macros are contained within a
startup file that won't load. What to do?

TIA,

 

[Ed Jay]

Ed Jay scribed:

Using Excel 2002 SP3 under XP-pro SP1.

I used a system cleaner and in the process I lost my custom toolbar
buttons with macros assigned. Additionally, when I launch Excel, it no
longer loads 'personal.xls,' contained in Excel/Start.

The buttons are easily replaced, but the macros are contained within a
startup file that won't load. What to do?

To follow up my own post...I've discovered that if I rename
'personal.xls,' the file auto loads as it should.

 

[Miyahn]

Using Excel 2002 SP3 under XP-pro SP1.

I used a system cleaner and in the process I lost my custom toolbar
buttons with macros assigned. Additionally, when I launch Excel, it no
longer loads 'personal.xls,' contained in Excel/Start.

The buttons are easily replaced, but the macros are contained within a
startup file that won't load. What to do?

Check this.
Help | About Micosoft Excel | Disabled Items

# I am not sure about English description of menu items.

 

[Ed Jay]

Miyahn scribed:

in message news:[email protected]

Check this.
Help | About Micosoft Excel | Disabled Items

# I am not sure about English description of menu items.

Thanks...the menus are the same. You were right on the money! I also found
'solver' listed. Now I know why it wasn't working either. Thanks.

 

[Gord Dibben]

Ed

Custom menus and toolbars are saved in the Excel10.xlb file.

Do a file search for *.xlb......there could be a few versions to choose from.

When you find the correct one, back it up regularly.

As far as Personal.xls working when you re-name it..............could be it has
been disabled as Personal.xls.

Check under Help?About MS Excel>Disabled Items.

Re-enable if you wish.


Gord Dibben MS Excel MVP

 

[Peo Sjoblom]

Make sure you are viewing hidden folders and files since at least the folder
in win xp is hidden


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com