Personal menus in Excel 2007
 

I have a .xls, Excel 2000, workbook with a personal menu generated by
code found on Chip Pearson's web site. I load the workbook into many
different machines, from an external hard drive, so I keep it in
..xls(2000) format. When I load it into Excel 2007, this personal menu
no longer appears on the default screen. I have to click an item
"Add-ins" and then find my personal menu listed there. One additional
mouse click. But mouse clicks add up. The whole purpose of the
personal menu was to bring frequently-used functions up out of the
dungeon.

My general observation of Excel 2007 is that it always takes one more
mouse click than it used to to do anything. Bigger and better training
wheels have been added, that can't be removed.

Forgive the rant.

Thanks for your help.

Fred Holmes

Personal menus in Excel 2007
 

Fred,

The Ribbon structure is a complete revamp of what Microsoft did in previous
versions of Excel (in terms of the menu structure). In my case, I had to
re-write the way my personal menu loaded because some of my existing control
IDs were not added in Excel 2007. Take a look at the following link:
http://www.oaltd.co.uk/Excel2007ProgRef/Default.htm and download the "Chapter
14 - RibbonX" pdf. I found this resource to be very helpful. (Of course,
you can search the web for Ribbon related items and you'll find a lot of
other information too).

Best,

Matthew Herbert

"Fred Holmes" wrote:

I have a .xls, Excel 2000, workbook with a personal menu generated by
code found on Chip Pearson's web site. I load the workbook into many
different machines, from an external hard drive, so I keep it in
..xls(2000) format. When I load it into Excel 2007, this personal menu
no longer appears on the default screen. I have to click an item
"Add-ins" and then find my personal menu listed there. One additional
mouse click. But mouse clicks add up. The whole purpose of the
personal menu was to bring frequently-used functions up out of the
dungeon.

My general observation of Excel 2007 is that it always takes one more
mouse click than it used to to do anything. Bigger and better training
wheels have been added, that can't be removed.

Forgive the rant.

Thanks for your help.

Fred Holmes

Personal menus in Excel 2007
 

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm



Fred Holmes wrote:

I have a .xls, Excel 2000, workbook with a personal menu generated by
code found on Chip Pearson's web site. I load the workbook into many
different machines, from an external hard drive, so I keep it in
.xls(2000) format. When I load it into Excel 2007, this personal menu
no longer appears on the default screen. I have to click an item
"Add-ins" and then find my personal menu listed there. One additional
mouse click. But mouse clicks add up. The whole purpose of the
personal menu was to bring frequently-used functions up out of the
dungeon.

My general observation of Excel 2007 is that it always takes one more
mouse click than it used to to do anything. Bigger and better training
wheels have been added, that can't be removed.

Forgive the rant.

Thanks for your help.

Fred Holmes

--

Dave Peterson

Personal menus in Excel 2007
 

Thanks, good information.

Fred Holmes

On Thu, 27 Aug 2009 10:44:53 -0500, Dave Peterson
wrote:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm



Fred Holmes wrote:

I have a .xls, Excel 2000, workbook with a personal menu generated by
code found on Chip Pearson's web site. I load the workbook into many
different machines, from an external hard drive, so I keep it in
.xls(2000) format. When I load it into Excel 2007, this personal menu
no longer appears on the default screen. I have to click an item
"Add-ins" and then find my personal menu listed there. One additional
mouse click. But mouse clicks add up. The whole purpose of the
personal menu was to bring frequently-used functions up out of the
dungeon.

My general observation of Excel 2007 is that it always takes one more
mouse click than it used to to do anything. Bigger and better training
wheels have been added, that can't be removed.

Forgive the rant.

Thanks for your help.

Fred Holmes