hi, instead of writing macros in the excel file that your are sharing write all the code in your own person xls. This will help you in preserving your code and re using macros on any excel you have. Check the below microsoft link to get more insight about Personal XLS.
http://office.microsoft.com/en-us/excel/HA010872961033.aspx On Wed, May 20, 2009 at 6:20 PM, ankur kochar <ankurkoch...@gmail.com>wrote: > Hi, > > I required a urgent help, I had an excel file which i want to work in > shared, but in that file I am using macro with VB codes, I want help how to > run the macro while working in shared file using by more than 1 person at > the same time. > > Please find the attached file for your reference. > > Any help on this will be really appreciated. > > Regards, > Ankur > > > > -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---