Thread: Export Toolbar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Export Toolbar

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

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)

chris wrote:

I created a custom toolbar that calls several macros to output certain
frequently used "ticks" at work. I was able to save the macros as an
add-in and can transfer that accordingly. However, on the toolbar, I
edited all the icons for each of the ticks by manually drawing the
wingding characters they create.

How do I export that actual toolbar and not just the macros that
support it?

Thank you.

Chris


--

Dave Peterson