+ Reply to Thread
Results 1 to 2 of 2

Tracking changes with Shared file

  1. #1
    Registered User
    Join Date
    09-16-2015
    Location
    Lisbon
    MS-Off Ver
    2010
    Posts
    1

    Tracking changes with Shared file

    Hi,
    I need to create a checklist that will be a shared filed. The users will need to populate one cell and I would need to keep track of the user that has performed that change. I can’t seem to use ENVIRON on VBA code. Probably it cannot be used with a shared file.
    Besides the option of Tracking changes on the file, is there any other option to do this’

    Thanks for the help,
    Catia

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Tracking changes with Shared file

    Hi there,

    Have you tried using

    Please Login or Register  to view this content.
    to retrieve the UserName, instead of retrieving it via Environ?


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

+ 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. ~file keeps opening and locking my Shared Excel File
    By akwishestofish in forum Excel General
    Replies: 0
    Last Post: 03-17-2015, 08:57 AM
  2. [SOLVED] Tracking file
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-16-2013, 12:41 PM
  3. Replies: 0
    Last Post: 09-06-2013, 05:31 AM
  4. Replies: 0
    Last Post: 04-12-2013, 07:38 AM
  5. Replies: 4
    Last Post: 10-21-2012, 06:00 PM
  6. Automatically saving file to shared file outside of outlook
    By pdmkh in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 08-13-2010, 12:34 AM
  7. Tracking changes to file
    By Jerome Ranch in forum Excel General
    Replies: 1
    Last Post: 04-27-2006, 07:55 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