I have a collection of macros in self madeup add-in XL2003. Now I have
switched over to XL2007.
How to make an additional tab/toolbar with custom buttons to launch chunk(s)
of a module, suppose:
1. Function N2W(Number) which requires an argument "Number" upon clicking a
button should present a popup box to select a cell containing the variable
"Number" instead of typing the whole function; and
2. Sub FormulaToValue1Sheet() executed on click of another button instead of
a shortcut key or selecting macro from Alt+F8 to execute?
--
Best Regards,
FARAZ A. QURESHI

Start here
http://www.rondebruin.nl/qat.htm

Or add a custom Ribbon tab
http://www.rondebruin.nl/ribbon.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"FARAZ QURESHI" wrote in message ...
I have a collection of macros in self madeup add-in XL2003. Now I have
switched over to XL2007.
How to make an additional tab/toolbar with custom buttons to launch chunk(s)
of a module, suppose:
1. Function N2W(Number) which requires an argument "Number" upon clicking a
button should present a popup box to select a cell containing the variable
"Number" instead of typing the whole function; and
2. Sub FormulaToValue1Sheet() executed on click of another button instead of
a shortcut key or selecting macro from Alt+F8 to execute?
--
Best Regards,
FARAZ A. QURESHI