automation error the object invoked has disconnected from its clie
 

My VB validation code works fine until I protect or share the worksheet. The
code works until it reaches the Add line in my validation code. Seems as
though my named range cannot be referenced. Any ideas?