PDA

View Full Version : Macros in a shared workbook



cmm0812
02-21-2008, 01:18 PM
Does anyone know of a quick and easy way to have macros run in a shared workbook (possibly by adding an extra line of code)?

Simon Lloyd
02-21-2008, 01:44 PM
cmm0812 macro's do run in a shared workbook!, if (i assume) you want to run external macro's in a shared workbook then all you have to do is store them in personal.xls, however if its a network saved workbook have a workbook with all your macro's in and call them from your shared workbook!

Simon Lloyd
02-21-2008, 01:50 PM
This will help you!
kb entry VBAX (http://www.vbaexpress.com/kb/getarticle.php?kb_id=279)