Running a macro in a predetermine range if not them msgBox
Hi KBREnner,
you should add test if user is in "allowed" area into your code.
Something like:
on error resume next
If Not Intersect(activecell, Range("b5..b159")) Is Nothing Then
on error goto 0
'here add what you want to do if "allowed" area
end if
on error goto 0
regards,
Ivan
|