hi,

i have created an excel spreadsheet that serves as a table (linked) for my
access database.
i want to prevent users from misentering data so i seek for two things:

first i want for each cell in column A users to be allowed to select only
from a list that i will create or, if possible from a table in access.
second i want to lock the programming of my spreadsheet (functions, list
data, etc.)

can you help me solve this problem?