prevent additional rows

  • Thread starter Thread starter accesspro
  • Start date Start date
A

accesspro

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
 
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
 
Thanks Rich.
Turns out in E2K i don't have the insert delete rows option.
But have to "unlock" each cell then protect, thanks.

bob
 

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

Prevent Insert Row and Delete Row from Menu 4
VBA - retrieve data on last create named range from previous inserted named range 0
Macro - Copy row base on criteria 3
Summarize data from multiple sheets 2
prevent pivot tables / charts from editing 1
How 2 lock row and column delete/add but allow data entry? 7
How do I display row numbers so I can click on a row? 3
Automatically Extend Formula in Count function with Additional Row 3

Back
Top