Rob_010101
Board Regular
- Joined
- Jul 24, 2017
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
Hi
I can't XL2BB as my work won't allow it:
I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then reapplying the same protection with the same password (workbook is protected to stop important data being accidentally amended).
The range to be sorted is G3:I24
Thanks
I can't XL2BB as my work won't allow it:
I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then reapplying the same protection with the same password (workbook is protected to stop important data being accidentally amended).
The range to be sorted is G3:I24
Thanks