View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default excel 2007 add custom menu

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.