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)

Nigel wrote:

I have created a custom toolbar with a worksheet. THe code for the buttons on
the toolabar are kept with the worksheet.

Is there anyway to keep the toolbar with the worksheet so if I send it to
someone else the toolbar will be there when they open the workbook

--

Dave Peterson

awesome, does EXACTLY what I needed

"Dave Peterson" wrote:

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)

Nigel wrote:

I have created a custom toolbar with a worksheet. THe code for the buttons on
the toolabar are kept with the worksheet.

Is there anyway to keep the toolbar with the worksheet so if I send it to
someone else the toolbar will be there when they open the workbook

--

Dave Peterson