Turn Audit Trail on and off

I am looking to only use the audit trail vba code when a command button is used. I have the following two options for audit trails - the first does not collect all of the information when used as a macro and the second gives an error for the target. Is it possible to selectively use code when it is assigned to a worksheet?

Please Login or Register  to view this content.

Here is the second one:

Please Login or Register  to view this content.