ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List auto-expansion with protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/148060-list-auto-expansion-protected-worksheet.html)

GH

List auto-expansion with protected worksheet
 
With Excel 2003, when I protect the worksheet the lists will no longer auto
expand. But if I don't protect the worksheet, the formulas are at risk.

Is there a way to keep the auto-expansion active while still protecting my
formulas?

Thanks for your help,
GH


All times are GMT +1. The time now is 07:47 PM.

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