User Profile

ANIL KUMAR N replied to compiler error:expected end sub

in Visual Basic

Oct 1 '14, 07:29 AM
pl's any body can help me it is very needed to me

See more | Go to post
Leave a comment:

ANIL KUMAR N started a topic compiler error:expected end sub

Oct 1 '14, 04:12 AM

compiler error:expected end sub

Code:

Sub LOCKED()
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rng As Range
Set Rng = Range("$a$1:$b$1")
If Not Application.Intersect(Target, Rng) Is Nothing Then
    Sheets("Sheet 1").Unprotect
    If IsEmpty(Target) Then
        Target.LOCKED = False
    Else
        Target.LOCKED = True
    End If
    Sheets("Sheet 1").Protect

...

See more | Go to post

Last edited by Rabbit; Oct 1 '14, 03:49 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.

No activity results to display

Profile Sidebar

Leave a comment:

compiler error:expected end sub