View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wind54Surfer Wind54Surfer is offline
external usenet poster
 
Posts: 16
Default Object variable or With block variable not set?

Hi all,

I am a newbie "programmer-wannabe" and have this code:

Private Sub Worksheet_Activate()

Dim wSheet As Worksheet

If wSheet.ProtectContents = False Then
ProductCaution.Show
Protection.Show
Else

End If
End Sub

Don't know what this error means:

"Object variable or With block variable not set"

Can someone please help.

Thanks in advance and Happy Easter,
Emilio