+ Reply to Thread
Results 1 to 2 of 2

Macro to open other workbook only if other workbook is not readonly

  1. #1
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Macro to open other workbook only if other workbook is not readonly

    Hello,
    Is there is simple and elegant way to do the following?
    Workbook A is the main macro based workbook which saves info onto workbook B. Looking for simple code to save the info in workbook B only if workbook B is editable, if workbook B is readonly then message code should pop up saying "Unable to save work, retry?"
    "No" should = exit sub and "yes" should retry opening in editable format and proceed with code.

    Thank you.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Macro to open other workbook only if other workbook is not readonly

    you can adapt this as needed:
    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ 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. Macro VBA to copy and paste cells from one open workbook to another open workbook
    By bloomingcarrot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2014, 07:55 PM
  2. [SOLVED] Open workbook if not readonly. If readonly try again.
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2014, 02:45 PM
  3. macro to copy cells(Range) from an open Workbook to another open Workbook.
    By jbester in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2013, 09:47 AM
  4. Macro to open a closed workbook and select copy cells into an open workbook
    By helloganesh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 02:00 PM
  5. Change workbook from readonly to compatiblity mode while in workbook
    By rasikvekaria in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-01-2012, 12:58 PM
  6. [SOLVED] Macro to copy data from open workbook to next open line of new workbook
    By nhtodd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 09:42 PM
  7. Workbook Open ReadOnly
    By KRAND in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2011, 11:59 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