close

Greetings!

I am creating a template. How do I prevent users from selecting the rest of
the cells except the five cells in which data will be entered (just like in
the Loan Amortization template)?

Thank You.

One way, unlock the cells you want data in, protect the sheet and uncheck
allow users to select locked cells

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Excel Userquot; lt;Excel gt; wrote in message
...
gt; Greetings!
gt;
gt; I am creating a template. How do I prevent users from selecting the rest
of
gt; the cells except the five cells in which data will be entered (just like
in
gt; the Loan Amortization template)?
gt;
gt; Thank You.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()