Great idea! Having done that it throws up the msgbox "The worksheet
wasn't found!". But I am still stuck....why would this worksheet exist
for some people and not for others. Also for one user it works
sometimes but not always. Why should rights to a worksheet be
intermittent? My VBA skills are fairly rudimentary so I don't have
enough knowledge of how rights to things work. Can anyone shed light?