PDA

View Full Version : Sharing a Workbook with VBA



nicka2511
02-04-2015, 12:33 PM
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
02-04-2015, 12:37 PM
Don't do it, you will regret it. The functionality is severely impaired, and sooner or later it will get corrupted.