Insert/ Delete rows of a protected worksheet.
Hi Dave,
Your quick response is much appreciated.
I am using Excel 2003.
I must admit that all the cells in a rows are not locked. First few are
unlocked and the rest are locked. its a mixture of both.
Is there any solution on this?
"Dave Peterson" wrote:
If you're using xl2002+, there's an option to allow the user to insert rows on
that tools|protection|protect sheet dialog. (I think all the cells in that row
will have to be unlocked, too.)
If you're using xl2k or below, maybe you could provide a macro that would
unprotect the sheet, do the insert and then reprotect the sheet.
quest4rachit wrote:
Hi All,
In my requirement I have to lock top 5 rows of the worksheet and the Cloumns
starting from AA to the last column, so that rest of the cells remains
editable to me.
I got sucess in doing so. With this another problem entered..
now I am unable to Insert / Delete the rows on Right Click...
Can any body please help me??
Or have any other alternative for doing this.
Please let me know for further clarifications.
Thanks in advance.
--
Dave Peterson
|