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?

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?

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?