Ivan, Thank you so much!
There is only one other thing I would like for the macro to do and that is
to give a MsgBox when On Error GoTo 0. I can live with out that nicesity,
I'll be looking for possible example in this forum and in Google to see if I
can figure it out!

Thanks, that really helps.
K Brenner


"Ivan Raiminius" wrote:

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