KeepItCool thanks for the explanation, i only grasped some of it
introduced Dim oWBAudit and then tried to make changes to the workshee
the code then stopped with the Error 424 and the highlighted line showe
oWBAudit = empty and Nothing =nothing.

I haven't the experience or in depth knowledge to be able to put thi
right, i am trying to capture which cell on which work sheet has bee
changed on which date and all that information to be entered in a
unopened workbook where it can later be checked by administration.

Hope you can help further!

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=26636