+ Reply to Thread
Results 1 to 3 of 3

Abort Workbook open if workbook is read only.

  1. #1
    Forum Contributor
    Join Date
    09-02-2005
    Posts
    146

    Abort Workbook open if workbook is read only.

    I've got several workbooks that users will be using to keep track of individual projects. These workbooks will talk back to a master summary sheet that has the status of all projects on it. The possibility exists that someone else on the network will have the summary book open when the program tries to update it, which would cause an error when it opens as read only. So I want to do something like this.

    Please Login or Register  to view this content.
    Last edited by wilro85; 12-13-2009 at 01:36 AM.

  2. #2
    Registered User
    Join Date
    12-08-2009
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Abort Workbook open if workbook is read only.

    I think this would do it:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-02-2005
    Posts
    146

    Re: Abort Workbook open if workbook is read only.

    Yep, that worked great. Thank you.

+ 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