Hi , my task is to update a workbooks specific sheet when i update another workbook.The catch is that the workbook that is to be updated the master database is on a shared drive and should not be opened or accessible to everyone.everyone has access to only his/her worksheet that he is updating