PC Review


Reply
Thread Tools Rate Thread

4.0 macros in Excel 2007

 
 
RBolten
Guest
Posts: n/a
 
      24th Mar 2009
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?
 
Reply With Quote
 
 
 
 
Homey
Guest
Posts: n/a
 
      24th Mar 2009
>>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" <(E-Mail Removed)> wrote in message
news:685B2932-6B73-4089-8AB9-(E-Mail Removed)...
|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?

 
Reply With Quote
 
RandyB
Guest
Posts: n/a
 
      25th Mar 2009
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" <(E-Mail Removed)> wrote in message
> news:685B2932-6B73-4089-8AB9-(E-Mail Removed)...
> |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?
>
>

 
Reply With Quote
 
Homey
Guest
Posts: n/a
 
      25th Mar 2009
Home should of given you a clue, so sorry. To make up for it, another
way -> Ctrl-F11

"RandyB" <(E-Mail Removed)> wrote in message
news:2ACF5FD0-ABD5-4B9F-9047-(E-Mail Removed)...
| 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" <(E-Mail Removed)> wrote in message
| > news:685B2932-6B73-4089-8AB9-(E-Mail Removed)...
| > |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?
| >
| >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the Excel 2007 rows limit for Excel 2003 macros? geet2ash Microsoft Excel Misc 0 12th Aug 2010 03:01 AM
Office 2007: how to import Excel macros created in Excel 2003 Daniel Microsoft Excel Discussion 4 21st Oct 2008 02:08 PM
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please Simon Microsoft Excel Programming 3 5th Aug 2008 03:48 PM
Excel 2007 macros - how to merge 5 macros together into one Sue Microsoft Excel Misc 1 16th Apr 2008 08:36 PM
Excel 2000 User Forms & Macros - Will they work with Excel 2007 John Microsoft Excel Programming 2 24th Nov 2007 06:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:17 PM.