Hi all! At the beginning of shift I have to open and share up to 30 workbooks. Can someone please suggest a macro or a function that I can insert into my master work book and which will share all open workbooks in one go? Thanks so much, regards, Itzik