call macro in a shared workbook

[Tezzies]

Everything worked great until.......I have a workbook called test1.xls which contains a macro which in turn calls a macro held within my other workbook called test2.xls. Since sharing the workbook test2.xls i am unable to call the macro using test1.xls.

The code used to call my macro is -----

Run ("Test2.xls!SaveandClose2") 'This line worked up until I shared test2.xls


I believe there are some limitations using shared workbooks have i found a big one or do you know of a workaround.

Many Thanks in advance

[mdmackillop]

Check out "Features that are unavailable in shared workbooks" in Excel Help.
You can save your code in an XLA file and load this as an Add-in. Have a look at this article