vba protected cells Solved/Closed

Question

Hello,  

I have used this code to protect sheets and i have made it not to select locked cells but when this code runs i can still select the locked cells,.. 

inputWks.Protect wsPwd, DrawingObjects:=False, Contents:=True, Scenarios:= _ 
        False, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:= _ 
        True 
   historyWks.Protect wsPwd, DrawingObjects:=False, Contents:=True, Scenarios:= _ 
        False, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:= _ 
        True

can anyone help??  

Configuration: Windows XP / Firefox 3.5.11

rizvisa1 · Answer

record the protection action and see what codes it generate. then use it

SARC · Answer

thanks..

these are the codes i got from recording the protection... but it doesn seem to record the select locked cells action.....

Vba protected cells

2 responses

Similar discussions

Subscribe To Our Newsletter!