The attached sample has an existing macro which creates different workbooks based on the data in column C. I am hoping someone can help add to this code by making the following updates:
1. For every new workbook created the column width is expanded to 15
2. For every new workbook created columns B, C, F, G H, I, O, P, T, U, V, X, AE, AJ and AK are hidden and locked.
3. For every new workbook created the entire workbook is password protected. Sample password can be: password.
Any assistance would be greatly appreciated! I am not very proficient in VB code and hoping some of you Excel/VB ninjas can figure this out.