Prevent Users from Selecting Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 & 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loan amortization schedule for variable interest rates 5
How do I change the loan period in a amortization from years to mo 7
change the payment period of amortization schedule 2
Amortization Schedule 11
Name Scope 2
First row where a cell is zero 1
change loan periods in an amortization schedule 2
Date function within loan amortization spreadsheets 3

Back
Top