I want to disable users to be able to insert new rows in-between the rows which already have information.
They should be able to edit the information in the existing rows and also if required be able to add more information in the last row, but should not be able to add new row in-between.
I tried the protect worksheet function but that locks all the cells and you are not able to edit the existing information also.
Any help on this will be appreciated.
A trick here would be:-
go to last row by pressing CTRL DownArrow, select entire row and add some dummy character like , or ` or anything, and just hide that last row...
If I've been of help, plz add reputation.
Excellent it does the magic!!! thank you so much
Thanks for feedback and Rep, happy to be of help!Originally Posted by sksachdev
You can mark the thread as Solved by selecting Thread Tools tab at the top right of the page and clicking Mark Thread as Solved link.
FYI, before you protect the spreadsheet, select the data range where you want to allow people to input data, i.e. A2:G500, right click>Format cells>Protection tab and uncheck "Locked" Then save the workbook. People will be able to enter data but not insert rows or columns.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks