ExcelBanter - Trying to set the Collate default to off.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Trying to set the Collate default to off. (https://www.excelbanter.com/excel-programming/300672-trying-set-collate-default-off.html)

No Name

Trying to set the Collate default to off.

I need to set the collate check box to default to off. everytime you go back in, it resets to on. I've seen that there is a flag cdlPDCollate &H10. But I have no idea what to do with it. Any help???

All times are GMT +1. The time now is 03:40 AM.