Enable To Run Macros
Ms Excel 2002
Dear Sir,
how are you,
basically i am working with a Bank & i have been assigned to collect some
data from Branches on Excel Sheets,
the problem lies that i dont want that they be able to ADD any Formula into
that sheet but only my formulas can be used!
so that there should be no WRONG Sum values!
so, what i have done is that i have search trhe folllowing code
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit
Application.EnableEvents = False
If Target.HasFormula Then
Target.Value = ""
MsgBox "Please Kindly dont Add any Farmula! Thanks", vbOKOnly
End If
ws_exit:
Application.EnableEvents = True
End Sub
but the problem is TO ENABLE RUNING MACROS,
& i dont think that all the users have good understanding with Excel and
Security Option!
i know you might take it as Hacking, but By GOD i dont mean or what to do
any Hacking,
Just want To AUTO ENABLE Running of MACROS without User permission
i hope you understand my pain! & like to help me out!
thanking you in advance
regards,
|