+ Reply to Thread
Results 1 to 2 of 2

Force to close all workbooks (shared) which opened by another users

  1. #1
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Question Force to close all workbooks (shared) which opened by another users

    I have a workbook which is shared.

    If I want to update or replace the shared workbook with updated data, it the same work book is opened by another user, is there any macro or VBA to close all opened workbooks before I update or replace.

    Thanks in advance.

    Joshi

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Force to close all workbooks (shared) which opened by another users

    Maybe this can help you.
    http://office.microsoft.com/en-us/ex...005262294.aspx

+ 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