Okay, I'm an XP user and I've been coding toolbars and shortcut menus in XL
for a decade or more. I've looked at several websites and I just don't get
the Ribbon. Look, my firm is cutting budget and they ain't gonna buy Visual
Studio, so all those articles that talk about that ain't helping me.

I need to replace the toolbar using XL as it comes out of the box using
nothing else, except what I can get free. AND, I need blow by blow
instructions on how to do it; i.e. no talk in step two about Com add-in's
because I've never had to use them before and I don't know what they are or
how to make one.

I need a practical user guide that steps you through how to manually
customize the ribbon without the lingo, just plain language - "here is how to
add a custom tab" or "here is how to add a custom button on the custom tab
you just added" and "this method gives you a button only on the current
workbook" and "this method gives you a button any time you load XL" and "here
is how you can distribute your code as though the file had a custom toolbar
in it..."

Is my frustration coming through? Can someone PLEASE recommend an excellent
book on this topic? or an excellent baby-step by baby-step "how to do this"
web site?

It's like I've hit a brick wall and I'm starting VBA programming 101 all
over again...please help... thanks.

While I have not played with customizing the Ribbon myself, perhaps one of
these might be of interest to you...

http://www.amazon.com/RibbonX-Custom...8195526&sr=8-4

http://www.amazon.com/RibbonX-Dummie...8195526&sr=8-1

Rick


"XP" wrote in message
...
Okay, I'm an XP user and I've been coding toolbars and shortcut menus in
XL
for a decade or more. I've looked at several websites and I just don't get
the Ribbon. Look, my firm is cutting budget and they ain't gonna buy
Visual
Studio, so all those articles that talk about that ain't helping me.

I need to replace the toolbar using XL as it comes out of the box using
nothing else, except what I can get free. AND, I need blow by blow
instructions on how to do it; i.e. no talk in step two about Com add-in's
because I've never had to use them before and I don't know what they are
or
how to make one.

I need a practical user guide that steps you through how to manually
customize the ribbon without the lingo, just plain language - "here is how
to
add a custom tab" or "here is how to add a custom button on the custom tab
you just added" and "this method gives you a button only on the current
workbook" and "this method gives you a button any time you load XL" and
"here
is how you can distribute your code as though the file had a custom
toolbar
in it..."

Is my frustration coming through? Can someone PLEASE recommend an
excellent
book on this topic? or an excellent baby-step by baby-step "how to do
this"
web site?

It's like I've hit a brick wall and I'm starting VBA programming 101 all
over again...please help... thanks.

On Mon, 14 Apr 2008 10:35:01 -0700, XP
wrote:

Okay, I'm an XP user and I've been coding toolbars and shortcut menus in XL
for a decade or more. I've looked at several websites and I just don't get
the Ribbon. Look, my firm is cutting budget and they ain't gonna buy Visual
Studio, so all those articles that talk about that ain't helping me.

I need to replace the toolbar using XL as it comes out of the box using
nothing else, except what I can get free. AND, I need blow by blow
instructions on how to do it; i.e. no talk in step two about Com add-in's
because I've never had to use them before and I don't know what they are or
how to make one.

I need a practical user guide that steps you through how to manually
customize the ribbon without the lingo, just plain language - "here is how to
add a custom tab" or "here is how to add a custom button on the custom tab
you just added" and "this method gives you a button only on the current
workbook" and "this method gives you a button any time you load XL" and "here
is how you can distribute your code as though the file had a custom toolbar
in it..."

Is my frustration coming through? Can someone PLEASE recommend an excellent
book on this topic? or an excellent baby-step by baby-step "how to do this"
web site?

It's like I've hit a brick wall and I'm starting VBA programming 101 all
over again...please help... thanks.


I haven't tried it, but maybe this could be of interest to you.

http://pschmid.net/office2007/ribbon...izer/index.php

Lars-Åke