I copied then pasted that Application.something when, while searching for possible reason/s why the system was taking several minutes to process a new record, I came across a post somewhere that the application.something lines could be added to make the macro run faster. I deleted the lines now then tried adding a new record but Excel automatically restarted when I hit the add button. Just when I thought I'm almost there at the completion stage, but now this.
As to checking smadav's settings, I'm afraid that is beyond my know how. I'll try anyway, thank you.