ExcelBanter - Prevent Autofill from changing protected cells formatting

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

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

- - Prevent Autofill from changing protected cells formatting (https://www.excelbanter.com/excel-programming/334203-prevent-autofill-changing-protected-cells-formatting.html)

Daren

Prevent Autofill from changing protected cells formatting

Any way I can prevent autofill from applying format changes to destination
cells that have been locked down so only values can be changed?

All times are GMT +1. The time now is 06:57 AM.