CALC: Worksheet change event & Calc access to macros

[Glenn1000]

I am en engineer migrating some macros from VB to OO. Generally everything has gone OK except for two problems:

1. In Excel we have spreadhseet which would call a macro whenever the spreadsheet data was changed. This macro would then check what was changed and if it was relevant perform some calculations and write the results back to the spreadsheet. In Calc I can find no similar event which a macro can be assigned to. Any suggestions?

2. We have a number of common macros used by a number of spreadsheets - these have been stored in a library in My Macros. When a spreadsheet opens it runs a macro which loads the library. The macros in the library are then exposed OK to basic macros in the spreadsheet, but don't seem to be available to the spreadsheet cell as a formula. Any suggestions as to how these can be exposed?

[ms777]