PDA

View Full Version : call macro in a shared workbook



Tezzies
02-19-2008, 07:11 AM
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
02-19-2008, 08:40 AM
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 (http://vbaexpress.com/forum/showthread.php?t=10855)