How to permanently customize a toolbar??

S

Sam

I added a "Paste Values" button to one of my toolbars.
{Right click toolbar, customize, Commands, Edit, Paste Values }

However, after I started a new session of Excel, the button was
no longer there. Is there a way to add a button to a toolbar, and
have it appear every time I start a new Excel session, or open a new Excel
document?

Thank you!
 
D

Dave Peterson

Perhaps you have multiple *.xlb files (where excel keeps track of your changes
to the toolbar) fighting each other.

I'd close excel
windows start button|Search
look for *.xlb
in hidden folders and for hidden files.

Rename them to *.xlbOLD. Then restart excel make that change. Close excel and
restart it.

If that icon is there, then delete the *.xlbOLD files. If not, rename them back
to *.xlb and keep searching for the answer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top