View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
 
Posts: 258
Default 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