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 ?