Error desipite UserInterfaceOnly in protection - Why?
I have protected the sheet with " UserInterfaceOnly:=True" and still, I
get - Sometimes! - error onfollowing line:
If
ActiveSheet.Range("D2:M2").SpecialCells(xlCellType Visible).Cells.Count
< _
Sheet2.Range("Years").Value Then
I don't know why, I get error and if I run the worksheet_activate event
again, it passes without a problem.
Please advice, this leavs me without a clue. Under what circumstances
doesn't "UserInterfaceOnly" cover events?
Regards,
tskogstrom
|