Allow rows to be inserted and edited in a protected worksheet

N

Noviceinexcel

I have a spreadsheet that I have to share with my colleagues. They have to
input information into columns 'J-M' and possibly column 'A'. If they are
entering info. for a new item (which was not originally on my spreadsheet)
then they need to insert new rows so as to enter the item data in Column A. I
did try locking the whole worksheet except Column 'J-M' and alowing them to
Insert Rows with the 'Protect Worksheet' function, but that blocked them from
entering new item data as Column A was locked. I do not want to unlock Column
A as I do not wish the integrity of the old tems in Column A to be affected.
I use Excel 2003. Please help.
 
J

John Bundy

I have something like this at work, I decided to create a form with a textbox
for each cell they would need to edit, and since the data needs to go in a
certain row, I have a RefEdit tool that lets them select which rows to place
it in between. I thought it might be complicated for them but I have had no
issues. After they enter information unprotect programatically and insert a
row and add data.
 
N

Noviceinexcel

Ok thanks John. Going back to your earlier answer what is a Refedit Tool and
how can I find out more?
 

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

Top