ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Autofill applying untwanted formats to protected sheet (https://www.excelbanter.com/excel-programming/333368-autofill-applying-untwanted-formats-protected-sheet.html)

Daren

Autofill applying untwanted formats to protected sheet
 
Is there anyway I can prevent autofill from applying formats to a cell range
when that cell range is protected? The worksheet is protected - the user can
chnage values but cannot apply formats.

Thanks


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com