Because of that the remove button code won't work.

Might well have worked too well - I've lost all of my menu's in Excel
playing around with this code and variations of it :-)

That couldn't have occurred directly as a result of what I posted.

Just in case I've caught you in time DO NOT close Excel. Find your *.xlb
file, back it up. Now quit Excel, rename the new xlb and replace with the
backup.

The *xlb file stores your toolbars and menus, it's updated when you quit
Excel.

Regards,
Peter T

"Jack Hoxley [MVP]" wrote in
message ...


"Peter T" wrote:
If you pasted all the code in my previous post and you are getting an
error
about not being able to find Macro1 you may have another similarly named
procedure.

I haven't had time to get to the bottom of it, but I suspect this is the
case. I'll look into it :)

"Peter T" wrote:
Because of that the remove button code won't work.

Might well have worked too well - I've lost all of my menu's in Excel
playing around with this code and variations of it :-)

Gives me an interesting excuse for not doing any work if nothing else...
"Sorry Boss, I can't do that" / "why not?" / "I have no menus anymore" ;-)


Probably be Tues next week before I get to look into this again, thanks
for
the help!

Jack