International Excel 4 Macro

[arun.darra]

I have a Excel 4 Macro sheet that looks like this:

Auto_Open
=ERROR(2;Recover)
=WORKBOOK.SELECT("Sheet 1")
=WINDOW.RESTORE()
=WINDOW.SIZE(82.5;42.75)
=WORKBOOK.HIDE("Macro1";TRUE)
=EDIT.COLOR(1;0;0;0)
=EDIT.COLOR(3;255;0;0)
=EDIT.COLOR(4;212;212;212)
=EDIT.COLOR(5;247;247;231)
=EDIT.COLOR(2;255;255;255)
=RUN("Macro5")
=DELETE.NAME("Auto_Open")
=WORKBOOK.SELECT("Sheet 1")
=SELECT("R1:R65536")
=COLUMN.WIDTH(;;;3)
=ROW.HEIGHT(;;;3)
=SELECT("R1C1")
=WINDOW.MAXIMIZE()
=RETURN()

Macro5
=WORKBOOK.SELECT("Sheet 1")
=SELECT("R2C1:R4C2")
=RUN("Macro1")
=SELECT("R2C3:R4C3")
=RUN("Macro2")
=SELECT("R2C3:R4C3")
=FORMAT.NUMBER("""$""###,###,##0.00")
=SELECT("R2C2:R4C2")
=FORMAT.NUMBER("dd-mmm-yyyy")
=SELECT("R1C1:R1C2")
=RUN("Macro3")
=SELECT("R1C3")
=RUN("Macro4")
=RETURN()

Macro1,Macro1,Macro3,Macro4 are formating macros...

How can i convert these macros into a "Excel 4 International Macro"
format

Regards
Arun

 

[Jim Rech]

Insert an International Excel 4 macro sheet into your workbook. Then copy
your code into it, recreate the sub names, etc., and test.

If the choice of an International macro sheet is not on your sheet Insert
menu you can run this code from the VBE's Immediate window:

Worksheets.Add , , , xlExcel4IntlMacroSheet

--
Jim
|I have a Excel 4 Macro sheet that looks like this:
|
| Auto_Open
| =ERROR(2;Recover)
| =WORKBOOK.SELECT("Sheet 1")
| =WINDOW.RESTORE()
| =WINDOW.SIZE(82.5;42.75)
| =WORKBOOK.HIDE("Macro1";TRUE)
| =EDIT.COLOR(1;0;0;0)
| =EDIT.COLOR(3;255;0;0)
| =EDIT.COLOR(4;212;212;212)
| =EDIT.COLOR(5;247;247;231)
| =EDIT.COLOR(2;255;255;255)
| =RUN("Macro5")
| =DELETE.NAME("Auto_Open")
| =WORKBOOK.SELECT("Sheet 1")
| =SELECT("R1:R65536")
| =COLUMN.WIDTH(;;;3)
| =ROW.HEIGHT(;;;3)
| =SELECT("R1C1")
| =WINDOW.MAXIMIZE()
| =RETURN()
|
| Macro5
| =WORKBOOK.SELECT("Sheet 1")
| =SELECT("R2C1:R4C2")
| =RUN("Macro1")
| =SELECT("R2C3:R4C3")
| =RUN("Macro2")
| =SELECT("R2C3:R4C3")
| =FORMAT.NUMBER("""$""###,###,##0.00")
| =SELECT("R2C2:R4C2")
| =FORMAT.NUMBER("dd-mmm-yyyy")
| =SELECT("R1C1:R1C2")
| =RUN("Macro3")
| =SELECT("R1C3")
| =RUN("Macro4")
| =RETURN()
|
| Macro1,Macro1,Macro3,Macro4 are formating macros...
|
| How can i convert these macros into a "Excel 4 International Macro"
| format
|
| Regards
| Arun
|