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