Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sam
 
Posts: n/a
Default How to permanently customize a toolbar??

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!
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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.

Sam wrote:

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!


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Toolbar problem Anthony Excel Discussion (Misc queries) 1 June 1st 05 01:05 AM
how do I add sum function to the toolbar permanently speedy2 Excel Discussion (Misc queries) 1 May 21st 05 03:53 AM
Is there a way to lock in the toolbar settings?? kydan47 Excel Discussion (Misc queries) 0 March 30th 05 02:13 PM
"Drawing" Toolbar is inactive Deauxx Excel Discussion (Misc queries) 1 December 8th 04 03:03 PM
How do I stop the Reviewing toolbar from showing up in Excel? RickKel Excel Discussion (Misc queries) 2 November 26th 04 05:37 PM


All times are GMT +1. The time now is 01:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"