Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat printing rows in multiple worksheets | Excel Discussion (Misc queries) |