Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
How do I keep an Excel macro that gets transferred to Pocket Excel | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |