I need to update the code for worksheet 'evals' in all workbooks named 'MyBook' on the network. I can get the workbooks and sheets no problem. I also have a master workbook with a worksheet that has the updated code.
What do I use to update the code from a master worksheet to these worksheets in excel 2007?
A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!)
David Miller (dlmille)
This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…