I have got a protected sheet in which some of the columns and rows are locked. Hence the user will not be able to edit these cells. But they can edit the unlocked cells.
i have set the lock property of all the cells in the sheet to unlock. Then i locked only the requried cells manually.
But when i am trying to create a new column next to locked column or new row next to the locked row, the newly created column or row is also getting locked which is not the desired output for me.
ie.if i am creating a new column (eg: after column A), then newly generated column (column B) is having the same format of Column A and hence the cells adjacent to locked cells(of column A) in column B is also getting locked.
i want the column B to be not locked, not having the same format as column A.
Am i clear on my requriements.
Thanks in advance...
Inserting rows and columns in protected sheet.
toreddie
Hi
Try copying a column/row with the format you want and inserting that to the place you want.
Regards
williamguy
it will not allow the user to insert the rows or columns since the sheet is protected. User will get a message box displaying the alert.
Even the user will not be able to select the required cells or rows where data has to be inserted.
Thanks,
Anulas