View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tskogstrom tskogstrom is offline
external usenet poster
 
Posts: 92
Default 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