ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   4.0 macros in Excel 2007 (https://www.excelbanter.com/excel-programming/425952-4-0-macros-excel-2007-a.html)

RBolten

4.0 macros in Excel 2007
 
I am too old to learn Visual Basic, but I'm not bad with Excel 4.0 macro
language. What do I have to do to get 4.0 macros to run in an Excel 2007
workbook? Is there a user's guide for this sort of thing?

Homey

4.0 macros in Excel 2007
 
What do I have to do to get 4.0 macros to run in an Excel 2007

Same as every other version of Excel, insert an Excel 4 sheet and enter your
code.

"RBolten" wrote in message
...
|I am too old to learn Visual Basic, but I'm not bad with Excel 4.0 macro
| language. What do I have to do to get 4.0 macros to run in an Excel 2007
| workbook? Is there a user's guide for this sort of thing?


RandyB

4.0 macros in Excel 2007
 
Yo, Homey--
Thanks, that did the trick! I think the hard part was figuring out HOW
to insert a 4.0 Macro sheet. The only way I found was to right-click the
tab, select "Insert", and then choose the "Excel 4.0 Macro" -- all of the
other methods just end up inserting a plain old worksheet.

Regards,
Randy

"Homey" wrote:

What do I have to do to get 4.0 macros to run in an Excel 2007


Same as every other version of Excel, insert an Excel 4 sheet and enter your
code.

"RBolten" wrote in message
...
|I am too old to learn Visual Basic, but I'm not bad with Excel 4.0 macro
| language. What do I have to do to get 4.0 macros to run in an Excel 2007
| workbook? Is there a user's guide for this sort of thing?



Homey

4.0 macros in Excel 2007
 
Home should of given you a clue, so sorry. To make up for it, another
way - Ctrl-F11

"RandyB" wrote in message
...
| Yo, Homey--
| Thanks, that did the trick! I think the hard part was figuring out
HOW
| to insert a 4.0 Macro sheet. The only way I found was to right-click the
| tab, select "Insert", and then choose the "Excel 4.0 Macro" -- all of the
| other methods just end up inserting a plain old worksheet.
|
| Regards,
| Randy
|
| "Homey" wrote:
|
| What do I have to do to get 4.0 macros to run in an Excel 2007
|
| Same as every other version of Excel, insert an Excel 4 sheet and enter
your
| code.
|
| "RBolten" wrote in message
| ...
| |I am too old to learn Visual Basic, but I'm not bad with Excel 4.0
macro
| | language. What do I have to do to get 4.0 macros to run in an Excel
2007
| | workbook? Is there a user's guide for this sort of thing?
|
|



All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com