Giving back

[Bony Pony]

Hi all,
In the spirit of giving back, I want to share with the Excel Community some
of the tools and utilities I have written.

Currently, these are acceseed and stored in my personal.xlsb file. There is
an auto open macro that builds a "right click" list that then access the bits
and bobs.

Do you suggest that a right click mechanism is the way to proceed or should
I create an addin with buttons that will then show up in the Addins section
of 2007?

I tried to create an addin from my personal.xlsb but the auto open macro
does not execute.

Any suggestions as to how to create something that is usable and shareable?

Kind regards,
Bony

 

[Dave Peterson]

First, don't use the name personal.*. I would imagine that some intended
recipient will have their own version of that file and won't be able to use
yours.

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)

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

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

 

[Bony Pony]

Hi Dave,
As usual a sensible post. Thanks for the tips!

Kind regards,
Bony
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."

First, don't use the name personal.*. I would imagine that some intended
recipient will have their own version of that file and won't be able to use
yours.

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)

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

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