close
I am trying to use a list on a protected worksheet, but whenever I go to
protect the worksheet, the bottom row in the list (the new entry row)
idsappears, and I am limited to the number of rows that existed prior to
locking the spreadsheet. I supposed I could enable to insertion of rows when
modifying the protection variables, but I would rather not do this. Instead
I want the list to expand automatically as new rows are typed into at the
bottom of the list so that formulas and format are continued within the list.
Please give any guidance...
全站熱搜
留言列表
