|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 15th, 2009, 08:01 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
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
December 15th, 2009, 09:27 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
December 15th, 2009, 11:02 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
December 15th, 2009, 11:53 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
December 16th, 2009, 01:28 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
December 16th, 2009, 02:34 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
December 16th, 2009, 05:05 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
December 16th, 2009, 05:06 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
