ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Prevent Users from Selecting Cells (https://www.excelbanter.com/excel-worksheet-functions/74749-prevent-users-selecting-cells.html)

Excel User

Prevent Users from Selecting Cells
 
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.

Paul B

Prevent Users from Selecting Cells
 
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

"Excel User" <Excel wrote in message
...
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.





All times are GMT +1. The time now is 03:01 AM.

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