Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

Custom tool bar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mikesee - 19 Mar 2008 21:43 GMT
In excel 2003 I can add a customized command to the top of the tool bar, but
when I close out of Excel, and re-open it goes away. Any Ideas?
Signature

Thanks!

Bernard Liengme - 19 Mar 2008 22:23 GMT
Home PC or on network?
Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

> In excel 2003 I can add a customized command to the top of the tool bar,
> but
> when I close out of Excel, and re-open it goes away. Any Ideas?
Dave Peterson - 19 Mar 2008 22:24 GMT
Customize your toolbar in code.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm  -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.

> In excel 2003 I can add a customized command to the top of the tool bar, but
> when I close out of Excel, and re-open it goes away. Any Ideas?
> --
> Thanks!

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.