prevent additional rows
highlight the cells you want data imput to be allowed in, and unprotect the
cell (s) or even select the whole page and unprotect all the cells
then go back into protection and protect the sheet making sure that the
insert \ delete rows options is not ticked
Rich
"accesspro" wrote:
I am using an Excel sheet to gather data from various users to import
into Access. Last year everything went well except a couple of users
either deleted or added rows, which screwed things.
Is there a way to prevent rows or columns from being added or deleted
and still allow data entry?
TIA
Bob
|