Frustrated with my ignorance of the ribbon

X

XP

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.
 
L

Lars-Åke Aspelin

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/ribboncustomizer/index.php

Lars-Åke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top