Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Missing macros

0 views
Skip to first unread message

oldjay

unread,
Dec 15, 2009, 3:01:02 PM12/15/09
to
I have a workbook created in Excel 97. All of the Menu Bar Macros run fine in
2003 but do not seem to be available in 2007.
Is there a way to convert them to work in 2007?

oldjay

Gord Dibben

unread,
Dec 15, 2009, 4:27:48 PM12/15/09
to
OJ

Check out Ron de Bruin's site for info on the Ribbon and QAT

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP

oldjay

unread,
Dec 15, 2009, 6:02:02 PM12/15/09
to
I am not talking about the standard button but ones I created in Excel 97i.e.
"Save Estimate" and "Start New Estimate".They had my macros attached

"Gord Dibben" wrote:

> .
>

Gord Dibben

unread,
Dec 15, 2009, 6:53:56 PM12/15/09
to
Where were the buttons located in Excel 97?

What type of buttons?

Toolbar and menu customizations made in Excel 2003 and earlier will not be
seen in 2007

That's why I posted Ron's site.

Shows you how to deal with menus and macros.

Specifically this page........

http://www.rondebruin.nl/qat.htm


Gord

On Tue, 15 Dec 2009 15:02:02 -0800, oldjay

oldjay

unread,
Dec 15, 2009, 8:28:01 PM12/15/09
to
These items on my workbook appear in the normal menu bar that shows File -
Edit - View - Format - Tools - Data - Windows - Help. The problem is that
the macros associated with these special items are not visible in 2003. I
believe that there was a "how to" article on how to modify these macros but I
can't find it. I was hoping some one would remember it

"Gord Dibben" wrote:

> .
>

oldjay

unread,
Dec 15, 2009, 9:34:01 PM12/15/09
to
Thanks for the help. I found a way to solve my problem.

Gord Dibben

unread,
Dec 16, 2009, 12:05:00 PM12/16/09
to
Could you share that solution?


Gord

Gord Dibben

unread,
Dec 16, 2009, 12:06:36 PM12/16/09
to
Excel 2007 does not have the same Menu Bar as earlier versions.

That's why I keep pushing you towards Ron's site.


Gord Dibben MS Excel MVP

0 new messages