#1   Report Post  
Old December 15th 09, 08:01 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 337
Default Missing macros

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

  #2   Report Post  
Old December 15th 09, 09:27 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Missing macros

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

On Tue, 15 Dec 2009 12:01:02 -0800, oldjay
wrote:

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


  #3   Report Post  
Old December 15th 09, 11:02 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 337
Default Missing macros

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:

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

On Tue, 15 Dec 2009 12:01:02 -0800, oldjay
wrote:

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


.

  #4   Report Post  
Old December 15th 09, 11:53 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Missing macros

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
wrote:

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:

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

On Tue, 15 Dec 2009 12:01:02 -0800, oldjay
wrote:

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


.


  #5   Report Post  
Old December 16th 09, 01:28 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 337
Default Missing macros

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:

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
wrote:

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:

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

On Tue, 15 Dec 2009 12:01:02 -0800, oldjay
wrote:

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

.


.



  #6   Report Post  
Old December 16th 09, 02:34 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 337
Default Missing macros

Thanks for the help. I found a way to solve my problem.

"oldjay" wrote:

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:

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
wrote:

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:

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

On Tue, 15 Dec 2009 12:01:02 -0800, oldjay
wrote:

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

.


.

  #7   Report Post  
Old December 16th 09, 05:05 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Missing macros

Could you share that solution?


Gord

On Tue, 15 Dec 2009 18:34:01 -0800, oldjay
wrote:

Thanks for the help. I found a way to solve my problem.

"oldjay" wrote:

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:

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
wrote:

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:

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

On Tue, 15 Dec 2009 12:01:02 -0800, oldjay
wrote:

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

.


.


  #8   Report Post  
Old December 16th 09, 05:06 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Missing macros

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

On Tue, 15 Dec 2009 17:28:01 -0800, oldjay
wrote:

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:

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
wrote:

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:

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

On Tue, 15 Dec 2009 12:01:02 -0800, oldjay
wrote:

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

.


.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM
Toolbars Missing, And option to Add Missing SmeetaG Excel Discussion (Misc queries) 3 October 19th 05 11:43 AM
Macros, Protected Books & Missing Passwords jamesanddavid Excel Worksheet Functions 1 April 15th 05 05:45 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017