Hi Steve

Would you mind adding this to your webpage to make it clear for guys like me

The problem is that people not read Steve.
I can add a lot of text but 95% of the people not read this

About unhiding the sheet for example to edit the menu
This is on the webpage and also in the text in the sheet of the example workbook.



--

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


"SteveDB1" wrote in message ...
Hi Ron.
Ok.... it appears that I've done it correctly. My last response is exactly
how it needs to be done.
And from what I can tell, I can keep adding, modifying, inserting rows in
the .xlsb file to keep adding my macros.
Would you mind adding this to your webpage to make it clear for guys like me
who are programming challenged?
I'll post this one as solved.
Enjoy your weekend-- if they have those in the Netherlands.
Best,
SteveB.

"SteveDB1" wrote:

Hi Ron,
Ok.... if I understand this correctly, you're stating that once I've clicked
the "unhide" and access the MyMacro.xlsb file, where I see the names of the
contents of your pop-up--
column B Column C
Caption Macro Name
Wi&zards
Wizard Number &1 MyMacro1
etc....
I edit the names of the macros (you've given-- MyMacro1, MyMacro2, etc...)
in column C (to match the names of my own), and that's where I can make the
necessary changes to activate my macros?
Here's where I feel somewhat stupid-- that it could/would be that simple,
yet so elegantly hidden.
Am I correctly understanding what you've stated?
SteveB.
"Ron de Bruin" wrote:

If you use the QAT example workbook it is very simple to edit your menu
From the webpage:

Edit the menu :

ViewUnhide in the ribbon
Select MyMacroFile and press OK


Or if you try the qat2.htm example

Edit the menu :

Right click on a sheet tab and choose Unhide if you want to change the menu
Or use "HomeFormat..Hide & Unhide" in the ribbon


Then edit the table you see with the macro names of your macros en the text you want to
see in the dropdown,


--

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


"SteveDB1" wrote in message ...
boy, you got that right!!!! argh!!!! :-(
Actually, I found your stuff already, and printed it out so that I can go
through it-- qat.html, and qat2.html files.
I've downloaded the mymacro.xlsb, and the myworkbook.xlsm files.
While I've gotten the drop down menus to work, I am not able to activate my
own macros when I place them in the new xlsb file.
All it appears to do is to de-activate your "wizard 1" macro, with the
message box stating that this is macro 1. I.e., it stopped activating a
message box with the statement "this is macro 1", nor will it perform the
task I've assigned in my macro.
Amazingly enough, I did use my drop-down menu routine to make a ribbon bar,
but the ribbon tab that I created won't allow me to edit its contents at all.
I need to get into each of those-- preferably the ribbon menu--those, place
my macros inside of them, with a name instead of an icon, and activate my
macros.
Cool qat toolbar though..... now if you can just tell me how its done to
make the modifications to each of the new qat menu items, I'll be in hog
heaven.
Thanks for your response.


"Ron de Bruin" wrote:

Hi Steve

Not so easy anymore like in the older Excel versions.

I have a simple dropdown menu example for the QAT on my site that is very easy to change
See the 2007 section on my site.

See also the ribbon page if you want to make your own ribbon tab

--

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


"SteveDB1" wrote in message ...
Hello all.
We just upgraded from Office 2000 to 2007 today, and while I backed up all
of my macros, (and they're still in their original locations that can readily
be accessed,) I'm not able to access them as I did before-- with one click
menu buttons.
My problem thus far is as follows:
1- I see where I can customize the new ribbon menu. I see where I can paste
the icons/macros to the ribbon toolbar. I cannot however identify where I can
change the icons to a name for my macro-- so that I actually remember what it
was it's suppose to be doing.
2- I'd come here a while back and a couple of guys gave me some code to make
a custom drop down menu. I've been able to activate that macro/menu, but now
I am not able to insert more macros on that custom menu/toolbar.
3- Perhaps belonging to item two-- I've noticed that there is a "toolbar
commands" under the customize quick-access toolbar. Under the customize
option at the left, and then pull down the "choose commands from" to "all
commands." Scroll down to the end of the T's, and you'll see it just above
"tools."
While this appears to be a "custom" toolbar that I could add in my macros of
choice for easy access, I see no means by which I can accomplish that.
a- the modify button is greyed out, and not accessible.
b- I'm not able to right click to make any changes as we did in older
versions.
So......
my questions are......
How do we make these changes in 2007?
1- I need to change from the image icons to names.
2 & 3, I need to have a series of custom drop down menus that I can place
all of my macros in, with names, for easy access.
Thanks in advance for your help.
Best to all!