Protect
Thanks but now I can insert row but cannot delete row.
Also there is no formula on newely inserted row.
Even cannot drag an copy the formulas unless otherwise unprotect.
"Francis" wrote:
Try this
Select the whole sheet by clicking on the left corner beside Col.A
Go to Format on the Tool bar
Choose Cells
Go to Protection tab and unclheck Locked
OK
Select the cells with formula that you want to protect, press and hold on to
Ctrl if they are in different ranges
Right click and choose Format Cells
Go to Protection tab
click Locked and Hidden
OK
Go to Protection and select Protect Sheet on the Tool bar
click on the options which you allow users to do in Allow all users of this
worksheet to
Apply your password
click OK
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
" VLOOKUP fORMULA" wrote:
Anybody please help me.....
I have a sheet1 contains formulas in column
B9:B32, C9:C32, E9:E32, K9:K32
I want to protect this formulas by accidently deleting the formula other
than me.
I know how to protect cells but my problem is that any body other than me
using this sheet.
They should only access to add or delete the rows
Is there any way the other user can add or delete rows and copy the formula
to new row without knowing the protected password.
Is it possible with any macro or code?
|