Hiya Eddie,
Sounds as though your on a network as I am in my work place???? I am locked out of the VBA Editor and I had a similar problem and all I did was hide the columns cause the data from the source is updated all the time.
Dont know if that will work with yours or not.
It does say solved but ohhh well.
Rob