Allow rows to be inserted and edited in a protected worksheet
 

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.

Allow rows to be inserted and edited in a protected worksheet
 

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Noviceinexcel" wrote:

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.

Allow rows to be inserted and edited in a protected worksheet
 

Thanks for the input, but the spreadsheet is very long, some 30 pages or more
and may not work as a form. Also I am not sure how to carry out what you
suggested as I am only aware of basic and some Intermediate features in
Excel.

"John Bundy" wrote:

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Noviceinexcel" wrote:

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.

Allow rows to be inserted and edited in a protected worksheet
 

Really, the only way to allow people to edit is to either unprotect it or add
it using code.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Noviceinexcel" wrote:

Thanks for the input, but the spreadsheet is very long, some 30 pages or more
and may not work as a form. Also I am not sure how to carry out what you
suggested as I am only aware of basic and some Intermediate features in
Excel.

"John Bundy" wrote:

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Noviceinexcel" wrote:

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.

Allow rows to be inserted and edited in a protected worksheet
 

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

"John Bundy" wrote:

Really, the only way to allow people to edit is to either unprotect it or add
it using code.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Noviceinexcel" wrote:

Thanks for the input, but the spreadsheet is very long, some 30 pages or more
and may not work as a form. Also I am not sure how to carry out what you
suggested as I am only aware of basic and some Intermediate features in
Excel.

"John Bundy" wrote:

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Noviceinexcel" wrote:

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.