Security level for macros in VBA

[Kamlesh Patel]

Dear Mr Excel,

We are in the process of making a form which is to be circulated to different individuals and after due filling the form the same will be submitted back to us.

In order to transpose all the data updated into uppercase, no matter whatever case it is updated we programmed the following in the VB code

"Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Target, Range("A1:A100")) Is Nothing Then
Target(1).Value = UCase(Target(1).Value)
End If
Application.EnableEvents = True
End Sub".

However the macro does not run if the security level of the pc (ie the pc at the users end) is high or medium.

Can the programme be altered in such a way that the macro runs in
the designed format no matter whatever the security level of that PC is .

 

[BrianB]

That would then defeat the purpose of having security levels.