How do I add a custom menu in Excel 2007?
I am used to use these in Excel 2000.

Hi ILearner

Creating a Popup menu with the old code is the only way in Excel 2007
Or you can change the ribbon

Look for examples in the 2007 section of my site

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


"ILearner" wrote in message ...
How do I add a custom menu in Excel 2007?
I am used to use these in Excel 2000.

Found it and got it working.
Crazy, the world turned upside down, you to supply free workarounds for
removed microsoft functionality.

How many menu's next to each other can there be created?
How can a workbook be assigned to be opened? Workbook.open() in a macro?

Sorry, but even as a workaround I need to decide if this is what I want.

I read some comment from somebody else and I agree: removing functionality
is destructive for Microsoft. Maybe I will learn how to work with macro's in
Open Office.

Thanks anyway.

"Ron de Bruin" wrote:

Hi ILearner

Creating a Popup menu with the old code is the only way in Excel 2007
Or you can change the ribbon

Look for examples in the 2007 section of my site

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


"ILearner" wrote in message ...
How do I add a custom menu in Excel 2007?
I am used to use these in Excel 2000.

The QAT example on my site is great for your own personal.xlsb file
Easy to change.

But for workbooks I suggest that you learn the Ribbon
http://www.rondebruin.nl/ribbon.htm

Do not look back, the ribbon is not so bad as you think.


--

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


"ILearner" wrote in message ...
Found it and got it working.
Crazy, the world turned upside down, you to supply free workarounds for
removed microsoft functionality.

How many menu's next to each other can there be created?
How can a workbook be assigned to be opened? Workbook.open() in a macro?

Sorry, but even as a workaround I need to decide if this is what I want.

I read some comment from somebody else and I agree: removing functionality
is destructive for Microsoft. Maybe I will learn how to work with macro's in
Open Office.

Thanks anyway.

"Ron de Bruin" wrote:

Hi ILearner

Creating a Popup menu with the old code is the only way in Excel 2007
Or you can change the ribbon

Look for examples in the 2007 section of my site

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


"ILearner" wrote in message ...
How do I add a custom menu in Excel 2007?
I am used to use these in Excel 2000.

Crazy, the world turned upside down, you to supply free workarounds for
removed microsoft functionality.

I agree, and I can only hope that Microsoft will take such criticisms and
suggestions to heart.

the ribbon is not so bad as you think.

Not as bad, perhaps, but I still greatly dislike it. I'm learning to deal
with it, but the entire interface leads to lower productivity. Even the
simplest tasks require more mouse movement and clicking than in earlier
versions of Excel. I also don't like the heavy-handed manner in which the
Office team thrust it upon us.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ron de Bruin" wrote in message
...
The QAT example on my site is great for your own personal.xlsb file
Easy to change.

But for workbooks I suggest that you learn the Ribbon
http://www.rondebruin.nl/ribbon.htm

Do not look back, the ribbon is not so bad as you think.


--

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


"ILearner" wrote in message
...
Found it and got it working.
Crazy, the world turned upside down, you to supply free workarounds for
removed microsoft functionality.

How many menu's next to each other can there be created?
How can a workbook be assigned to be opened? Workbook.open() in a macro?

Sorry, but even as a workaround I need to decide if this is what I want.

I read some comment from somebody else and I agree: removing
functionality is destructive for Microsoft. Maybe I will learn how to
work with macro's in Open Office.

Thanks anyway.

"Ron de Bruin" wrote:

Hi ILearner

Creating a Popup menu with the old code is the only way in Excel 2007
Or you can change the ribbon

Look for examples in the 2007 section of my site

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


"ILearner" wrote in message
...
How do I add a custom menu in Excel 2007?
I am used to use these in Excel 2000.

Jon

I agree it has some features which are a 'backward' step (tearing off to put
near work, being the worsed), but the more I work with it the better I find
the customisation story. Apart from the 'camelCase' in the xml, which takes
a little longer to get used to and little quirks like dialogBoxLauncher
needing to be declared last in a group, I find it far better and more
forgiving in a strange way. That is you either get the ribbon look you want
or nothing. Somehow it's much nicer than shouting at a syntax dialog!

I was stumped with dynamic stuff, but am now starting on that road.

Granted, for casual users, they really only have the QAT to customise, maybe
a tear-off QAT would help them.

I really like the feature of dragging custom controls onto the QAT and they
just work!

On usability, the quickest way around Excel is keyboard and *most* of the
old keyboard settings still work.

Lastly, to just not load the ribbonX and the UI is exactly as it was is a
major step forward. The number of 'stray' custom toolbars I've seen is
without number. XL4 had two toolbars, 2003 had 32! Something had to change
and lets hope this is V1, but IMVHO, it ain't as bad as some think...just
very different. (my £0.02)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Jon Peltier" wrote in message
...
Crazy, the world turned upside down, you to supply free workarounds for
removed microsoft functionality.

I agree, and I can only hope that Microsoft will take such criticisms and
suggestions to heart.

the ribbon is not so bad as you think.

Not as bad, perhaps, but I still greatly dislike it. I'm learning to deal
with it, but the entire interface leads to lower productivity. Even the
simplest tasks require more mouse movement and clicking than in earlier
versions of Excel. I also don't like the heavy-handed manner in which the
Office team thrust it upon us.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ron de Bruin" wrote in message
...
The QAT example on my site is great for your own personal.xlsb file
Easy to change.

But for workbooks I suggest that you learn the Ribbon
http://www.rondebruin.nl/ribbon.htm

Do not look back, the ribbon is not so bad as you think.


--

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


"ILearner" wrote in message
...
Found it and got it working.
Crazy, the world turned upside down, you to supply free workarounds for
removed microsoft functionality.

How many menu's next to each other can there be created?
How can a workbook be assigned to be opened? Workbook.open() in a macro?

Sorry, but even as a workaround I need to decide if this is what I want.

I read some comment from somebody else and I agree: removing
functionality is destructive for Microsoft. Maybe I will learn how to
work with macro's in Open Office.

Thanks anyway.

"Ron de Bruin" wrote:

Hi ILearner

Creating a Popup menu with the old code is the only way in Excel 2007
Or you can change the ribbon

Look for examples in the 2007 section of my site

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


"ILearner" wrote in message
...
How do I add a custom menu in Excel 2007?
I am used to use these in Excel 2000.