New to VBA but through lots of internet searching and with help from this forum I have managed to put together a project that handles inventory control for my company. After months of putting this together I discovered horrifyingly, I can’t share a macro enable workbook. I then found snippets on the net suggesting that you could have one workbook for Data where all the data and all transactions are stored and recorded and another workbook that would be the Interface where all the macros run and user forms reside. These macros and user forms are used to call on the Data workbook to run stock and data checks and to record stock transaction through the user forms. The idea being that each PC has their own copy of the Interface and the Data would sit on a network drive. Could someone confirm whether this would be possible and whether this is a relatively simple task?