WorKsheet Protection

Maxonelife

New Member
Joined
Dec 5, 2005
Messages
1
Is there Any way in that i can set a number of worsheet under such a protection that other people accessing IT are able to amend data (i.e INPUT DATA N SEE IT)in it but are not able to DELETE THE WORK SHEET.....
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
Yes iif you protect the workbook for structure and do not protect sheets at all, they will not be able to delete, but they will be able to edit at will.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,083
Members
412,566
Latest member
TexasTony
Top