+ Reply to Thread
Results 1 to 1 of 1

Audit log that shows data cycled by a macro button

  1. #1
    Registered User
    Join Date
    07-19-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    37

    Audit log that shows data cycled by a macro button

    Having a bit of a nightmare with this.

    I have set up a workbook with an audit log that tracks: Cell changed, sheet changed, old value, new value, date, time and username.

    However, the audit doesn't work when the data is cycled by a button on each worksheet. This button simply moves top row of data to the bottom and is:
    Please Login or Register  to view this content.
    What I want the audit to log is what data was in the top row before it was cycled. It could even show what was after if that is easier.


    This code works well, except it doesn't show what data is cycled by the button:

    Please Login or Register  to view this content.
    I have been staring at this for a while and no matter what I tweak, nothing seems to get the button to work with the audit.

    Thanks in advance.
    Last edited by C_P; 09-27-2019 at 11:09 AM.

+ 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. ComboBox DropDown Button: ShowDropButtonWhenNever - Button still shows.
    By melpa in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 09-29-2019, 05:10 AM
  2. Macro only shows "create" button. Can't run/edit/delete.
    By nbpat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-31-2019, 03:44 AM
  3. Macro to filter Data Shows details but data disappears or does not show all
    By AmandaM73 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2019, 12:20 AM
  4. Replies: 2
    Last Post: 07-05-2016, 08:12 PM
  5. [SOLVED] Need a macro to do a random 10% Audit
    By ciresuark in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-05-2015, 10:08 AM
  6. [SOLVED] Macro shows three seperate data ranges in line graph
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2015, 05:36 PM
  7. [SOLVED] Hide Worksheet Macro shows data before password prompt
    By Steve N. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2012, 06:19 PM

Tags for this Thread

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