after creating macro button, closed excel then restarted excel. b.

H

hankd74

I created the macro button on the toolbar. created the macro then assigned it
to that button and changed the button image and text. I've done this
countless times with no problems but now something is different. It created
fine and everything worked after testing it out BUT once i closed out excel
and restarted it just briefly i see the button then it disappears. I've done
it several times, each time i put it into a different toolbar. Makes no
difference wher i put it. It still disappears and i have to create it al over
again. I can't leave excel open forever so i won't loose it. What be the
problem? What am i missing after all these years!
 
D

Dave Peterson

I'm guessing that you may have multiple *.xlb files hanging around.

Close excel
I'd use windows start button|search(or find)
and search for *.xlb

If you find multiple versions, you may want to rename all of them to *.xlbOLD.
Then go back to excel and make a change to the toolbar.

Then close excel and do another search.

You should find the one *.xlb file that excel just created.

If you can determine which of the multiples you want to keep, move into its
rightful home and rename it (delete the temporary version, too).

Or you could just dump all the *.xlb files and recreate the toolbars.

For me (win98 and xl2002), my toolbar is located in:
C:\windows\application data\microsoft\excel
and it's named excel10.xlb.

(I'm guessing that you have an offending *.xlb in your XLStart folder.)
 
H

hjd43

Dave, sorry about taking so long to reply. ended up in hospital but ok now.
You were right about the .xlb's i found an old excel8.xlb. once i removed it
all went back to normal. Thanks for the superb advice. Hope i can return the
favor sometime.
 
D

Dave Peterson

There are a lot of Dave's around here and I'm sure all of them are happy you got
it working and are doing better now.
 
Top