+ Reply to Thread
Results 1 to 5 of 5

Audit trail for copy / pasting

  1. #1
    Registered User
    Join Date
    07-02-2018
    Location
    Drunen
    MS-Off Ver
    2013
    Posts
    60

    Audit trail for copy / pasting

    Hi, i`m using the following code for my audit trail :

    Please Login or Register  to view this content.
    This works perfect for single cells, however we would like to be able to copy and paste multiple cells and keep using the audit trail. Any suggestions?

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Audit trail for copy / pasting

    Use "Track Changes".
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    07-02-2018
    Location
    Drunen
    MS-Off Ver
    2013
    Posts
    60

    Re: Audit trail for copy / pasting

    That would be a good solution, however there are several macro`s in this shared workbook. They won`t run in a shared workbook.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Audit trail for copy / pasting

    Macros should run in a shared workbook (depending on what they're trying to do), you just can't edit them.

  5. #5
    Registered User
    Join Date
    07-02-2018
    Location
    Drunen
    MS-Off Ver
    2013
    Posts
    60

    Re: Audit trail for copy / pasting

    Let me rephrase, my macro`s won`t run in a shared workbook. Any tips what i should edit/look for? This is the current code:
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Audit trail not working
    By BSAGAERT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2017, 11:27 AM
  2. Audit Trail
    By thong127 in forum Excel General
    Replies: 2
    Last Post: 04-26-2017, 09:38 AM
  3. [SOLVED] Audit Trail with VBA!
    By Keibri in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2016, 04:11 AM
  4. Audit Trail
    By Moggzzz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2016, 06:48 AM
  5. Audit Trail
    By jenziepie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2013, 01:56 PM
  6. Excel Audit Trail?
    By jvest0648 in forum Excel General
    Replies: 1
    Last Post: 12-17-2011, 02:57 PM
  7. Audit Trail
    By Pendelfin in forum Excel General
    Replies: 1
    Last Post: 01-23-2006, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1