+ Reply to Thread
Results 1 to 1 of 1

VBA objects, properties and methods for coauthoring

  1. #1
    Registered User
    Join Date
    01-07-2004
    Location
    New York
    Posts
    1

    VBA objects, properties and methods for coauthoring

    Office 365 and Office Online permit coauthoring of workbooks via sharing a OneDrive link. Anyone who is editing the workbook is visible as an icon on the right side of the menu bar. Clicking about reveals who is editing, what they are editing, and who was (but is no longer) editing.

    Are there VBA objects, properties and methods for retrieving this same information?

    Background:

    I am a board member of a large not-for-profit amateur athletic organization that hosts regional, national and international competitions. To manage the competitions, we use WiFi-connected tablets running shared collaborative Excel worksheets on OneDrive. Because the competitions are spread out over multiple locations with lots of mobile and stationary sources of interference, WiFi strength fluctuates. Sometimes the signal disappears entirely.

    When this occurs, we need to know who is disconnected and thus unwittingly making changes to a now-unshared workbook. The active editor list is passively available via the coathoring icons, but we need proactive alerts for both the disconnected user and the rest of the competition management team.

    Thank you in advance for your assistance.
    Last edited by PatFinegan; 09-20-2018 at 02:27 PM.

+ 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. return object methods or properties
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2017, 12:50 PM
  2. [SOLVED] Optional arguments for properties and methods
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2013, 04:44 PM
  3. Objects, Properties and Methods
    By noclass1980 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2012, 06:34 AM
  4. Objects, Properties and Methods
    By noclass1980 in forum Excel General
    Replies: 0
    Last Post: 10-09-2012, 02:33 AM
  5. Properties/Methods List
    By mcbuddah in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-24-2010, 11:25 AM
  6. [SOLVED] Hidden workbook properties/methods
    By R Avery in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2005, 03:06 PM
  7. [SOLVED] HELP! Object, Properties & Methods
    By dee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2005, 07:06 PM

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