Protect cell - VBA

  • Thread starter Thread starter Avi
  • Start date Start date
A

Avi

Hi,

I want to protect cells of a particular color usning this code

Sub Protectme()
For i = FirstRow To RowCount 'row
For j = FirstCol To Colcount ' col
If CellColorIndex(Cells(i, j)) = 24 Then
Range.Cells(i,j).Locked = True --- Some problem in this line
End If
Next j
Next i
ActiveSheet.Protect
End Sub

This gives me a run time error.. Can somebody help me ??

Thanks,
Avinash
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA Array Function...What's wrong? 4
Merging cell using VB for Excel 4
retrieve data from an .aspx web page 5
Find string from column A in Range("B2:F7") list the header of that column/s 5
count cells with diagonal borders 3
Add Column Names to VBA script 1
Add the word "and" in my code 12
Sum At Top And Move Cells Down in VBA 3

Back
Top