- Feb 12, 2007
I have 30+ supervisors who each have their own workbook containing data in a (for our company) standard format. I have a master workbook that reads the data from each supervisor workbook, massages it, and re-writes it to the individual workbooks. The massaging may take several minutes. I want to lock all the workbooks BEFORE I read in the data and then unlock it AFTER I write the data. Is there some way, other than leaving them open (they all have the same name), to use VBA to lock the workbooks until I'm done with them?