ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do use list with protect sheet function? (https://www.excelbanter.com/excel-discussion-misc-queries/72538-how-do-use-list-protect-sheet-function.html)

quantn

How do use list with protect sheet function?
 
I created 1 list with "input data column" and "Match column".

I set property for "Match column" is protect (for auto-works), and "input
data column" is free.

And protected sheet. List can't expand, even though "Allow.... insert row"
is on


All times are GMT +1. The time now is 02:48 PM.

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