Sharing a Workbook with VBA

[nicka2511]

I have a workbook that I have quite and extensive macro as well as tables linked from a database, I want to be able to share that workbook so multiple users can use it at once. I know that with the share workbook button in Excel 2010 this is not possible without breaking the table link back to the database, do you now if it is possible to have VBA code that would share the workbook under these circumstances?

[Bob Phillips]

Don't do it, you will regret it. The functionality is severely impaired, and sooner or later it will get corrupted.