Forum Discussion

waygar's avatar
waygar
Copper Contributor
Feb 07, 2024
Solved

Sharepoint Workbook reversion to earlier version due to Internet link broken VBA

A group of eight geographically separated people coauthor an Excel macro-enabled Workbook located on a Sharepoint Server. This system works well with editing by each of the group being autosaved to t...
  • JKPieterse's avatar
    Feb 07, 2024

    waygar You could use the trick I implemented in the attached file. Note that there is code in both Module1 and in ThisWorkbook. What I don't like about the solution is that the mouse cursor flashes every time the code runs. You may want to make it run less frequent by adapting the Timevalue argument.

Resources