I am new to Excel 2007 and have two questions. 1. In previous versions, i
was able to create a custom menu bar as a drop down from the top menu and add
macros to it. I could do all of this without having to go in and write code.
Now in 2007, i see how to add a menu bar to the quick access tool bar, but i
can't figure out how to assign macros to that menu bar. Any ideas? 2. How
do you go about creating an add-in that other users could add to their
computer and use? I have never done this before and wanted to know if that
is a good way to share a custom menu bar or tool bar?
Thanks.

JD McLeod brought next idea :
> I am new to Excel 2007 and have two questions. 1. In previous versions, i
> was able to create a custom menu bar as a drop down from the top menu and add
> macros to it. I could do all of this without having to go in and write code.
> Now in 2007, i see how to add a menu bar to the quick access tool bar, but i
> can't figure out how to assign macros to that menu bar. Any ideas? 2. How
> do you go about creating an add-in that other users could add to their
> computer and use? I have never done this before and wanted to know if that
> is a good way to share a custom menu bar or tool bar?
> Thanks.

Yes, creating an addi is probably the easiest approach because you can
control and maintain the macros in a common toolbar rather than having
to get users to update their custom menus. The menus/toolbar will
appear on the Addins tab of the ribbon.

How To:
Put your code in a workbook saved as an addin (.xla). Include code to
build the toolbar and manage it between sessions so it creates itself
on startup and removes itself on shutdown. Do your programming in the
earliest version of Excel you expect users to have.

Books I recommend:
Excel <version> Power Programming with VBA
by John Walkenbach

Excel <version> VBA Programmer's Reference
by Bovey, Bullen, Green

Additionally, there are many people here in this NG that will help you
along the way!

regards,
Garry

I'm lazy enough to live with the old method -- but I have to look in the Addins
tab on the ribbon to find my customized toolbars.


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

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/ar...me-simple.aspx

JD McLeod wrote:

> I am new to Excel 2007 and have two questions. 1. In previous versions, i
> was able to create a custom menu bar as a drop down from the top menu and add
> macros to it. I could do all of this without having to go in and write code.
> Now in 2007, i see how to add a menu bar to the quick access tool bar, but i
> can't figure out how to assign macros to that menu bar. Any ideas? 2. How
> do you go about creating an add-in that other users could add to their
> computer and use? I have never done this before and wanted to know if that
> is a good way to share a custom menu bar or tool bar?
> Thanks.

--

Dave Peterson

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:%23rDKB%(E-Mail Removed)...
> I'm lazy enough to live with the old method -- but I have to look in the
> Addins tab on the ribbon to find my customized toolbars.
>
>
> 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
>
> And Bob Phillips shows a way to use a wrapper so that it can work in both
> xl2003
> and xl2007.
> http://msmvps.com/blogs/xldynamic/ar...me-simple.aspx


Nothing gets by you does it? <bg>

You shared that info to another post. So I figured I'd just add it into one of
my "saved from a previous post" replies.

I figured I'd save you some time! <vbg>

Bob Phillips wrote:

> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:%23rDKB%(E-Mail Removed)...
>
>>I'm lazy enough to live with the old method -- but I have to look in the
>>Addins tab on the ribbon to find my customized toolbars.
>>
>>
>>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
>>
>>And Bob Phillips shows a way to use a wrapper so that it can work in both
>>xl2003
>>and xl2007.
>>http://msmvps.com/blogs/xldynamic/ar...me-simple.aspx
>
>
>
> Nothing gets by you does it? <bg>
>
>

--

Dave Peterson

Hi Bob,

Very nice article! Well done! Props to you...
So nice that I think I might actually try it with my next
workbook-based addin for MSO12+ clients.

I thought about doing similar to this before I decided to make all my
apps COMAddins, but I couldn't resolve the lack of security that tags
along with it. I now do the same thing via code as outlined in Excel
2007 VBA Programmer's Reference. It simply checks version of the host
app to determine what to do. Since my addins are task-specific, I only
use an automated instance where I hide everything except the tab with
my menus. This would be the built-in Addins tab because my menus are
all that's there, AND I still use Rob's table-driven CommandbarBuilder
wrapper for creating custom menus/toolbars as a matter of convenience.
That's about the only code in the xla I open, except for the sub that
passes the entry point parameters to the COMAddin. It's also a single
proc used by all menus, which passes their OnAction via the Tag prop
and any parameters as a delimited string via the Parameter prop.

Lots of similarities but not as easy as the old days, huh!

Regards,
Garry

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> You shared that info to another post. So I figured I'd just add it into
> one of my "saved from a previous post" replies.


That is what I mean, you see everything. I think there are lots of you in
reality, Dave Peterson is really a franchise <ebg>

Or just retired with nothing better to do!



Bob Phillips wrote:

> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>
>>You shared that info to another post. So I figured I'd just add it into
>>one of my "saved from a previous post" replies.
>
>
>
> That is what I mean, you see everything. I think there are lots of you in
> reality, Dave Peterson is really a franchise <ebg>
>
>

--

Dave Peterson

This was supposed to be a reply to Bob.

Dave Peterson wrote:

> Or just retired with nothing better to do!
>
>
>
> Bob Phillips wrote:
>
>> "Dave Peterson" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>
>>
>>> You shared that info to another post. So I figured I'd just add it
>>> into one of my "saved from a previous post" replies.
>>
>>
>>
>>
>> That is what I mean, you see everything. I think there are lots of you
>> in reality, Dave Peterson is really a franchise <ebg>
>>
>

--

Dave Peterson

Hmmm.

The headers must have gotten confused in my newsreader. Now my response to Bob
shows up as a response to Bob. But my response to my response is under GS's
message.

Hmmm.

Dave Peterson wrote:

> This was supposed to be a reply to Bob.
>
> Dave Peterson wrote:
>
>> Or just retired with nothing better to do!
>>
>>
>>
>> Bob Phillips wrote:
>>
>>> "Dave Peterson" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>
>>>
>>>> You shared that info to another post. So I figured I'd just add it
>>>> into one of my "saved from a previous post" replies.
>>>
>>>
>>>
>>>
>>>
>>> That is what I mean, you see everything. I think there are lots of
>>> you in reality, Dave Peterson is really a franchise <ebg>
>>>
>>
>

--

Dave Peterson