+ Reply to Thread
Results 1 to 2 of 2

Share Workbook - Update Changes

  1. #1
    Registered User
    Join Date
    09-04-2006
    Posts
    29

    Share Workbook - Update Changes

    If you choose to share your workbook. You can choose to update the changes every "something" minutes.
    Tools-->Share Workbook-->Advanced Tab-->Update Changes Section

    The smallest amount of time that it lets you choose is 5 minutes. The problem that I have is that I want to change the amount to 1 or 2 minutes. Is there anyway that this can be done???

    I'm assuming if this can be done it would be done through vba thats why im posting it here.

    Thanks in Advance
    Ben

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Lightbulb Auto save

    An idea may be this:

    put next code in workbook_open event:
    Application.OnTime Now + TimeValue("00:01:00"), "my_Procedure"


    then insert a module and include the next code:
    Sub my_Procedure()
    ActiveWorkbook.Save

    Application.OnTime Now + TimeValue("00:01:00"), "my_Procedure"
    End Sub

    That will save workbook each minute (the time is in format hour:minute:seconds).

    Regards,
    Antonio

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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