Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Creating XL4 macros ?

  Asked By: Lorraine    Date: Mar 21    Category: MS Office    Views: 1344
  

I have a spreadsheet with the legacy XL4 macros.
I want to add a macro to the already existing sheet.
I tried to type a simple macro as below

sub_test
=ALERT(hi)
=RETURN()

This macro doesnt show up in the list of available
macros in the run macros dialog box.but if I type in
sub_test into the Macro name field on the run macros
dialog, it starts running the macro.

Can someone tell me the following:

1. How to declare sub_test as a macro ?
2. how to declare a XL4 macro which runs when the
workbook is opened?
3. Any links to learn about XL4 macros usage ?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Creating XL4 macros ? Or get search suggestion and latest updates.




Tagged: