Audit trail saved in a separate, password protected Excel file?

Hi all,

I would like to save an audit trail from my Excel file into a separate, password protected Excel file (so that the logged details cannot be viewed or altered by unauthorised people).

What should I add to the VBA code listed below?

Also, is it possible to define the name of the worksheet in this separate Excel file (e.g. to be named 'audit trail')?

The code in the attached file:

Please Login or Register  to view this content.

Any help will be greatly appreciated.

Thanks

MP