+ Reply to Thread
Results 1 to 5 of 5

How to open password protected workbook with readonly false

  1. #1
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    How to open password protected workbook with readonly false

    Hi,

    i have writen below code to open password protected workbook with readonly recommendation.
    however it is opening file as readonly

    can someone help

    Please Login or Register  to view this content.
    Thank you

    If I have helped you in someway, use the * icon below to give reputation feedback, it is appreciated.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: How to open password protected workbook with readonly false

    Try changing this...
    Please Login or Register  to view this content.
    to...
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    Re: How to open password protected workbook with readonly false

    Quote Originally Posted by dangelor View Post
    Try changing this...
    Please Login or Register  to view this content.
    to...
    Please Login or Register  to view this content.
    This isn't working.
    The file which i have protected , is protected with readonly recommendation.

    while opening it will ask for password , also below option to click on readonly for users who dont have password just to see data.

    With the above code, the same window that i am getting to input password and a redonly option at botto.

  4. #4
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    Re: How to open password protected workbook with readonly false

    can somebody help me please

  5. #5
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: How to open password protected workbook with readonly false

    Try this...
    Please Login or Register  to view this content.

+ 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. VBA to open a password protected workbook
    By Larry.LeBlanc@O in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-07-2016, 11:02 AM
  2. How to open password protected workbook?
    By ImranBhatti in forum Excel General
    Replies: 4
    Last Post: 09-20-2016, 02:33 AM
  3. [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
  4. Open, copy and save to password protected workbook
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 11:46 AM
  5. [SOLVED] Password array to open all password protected workbook in a folder
    By rename in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-07-2012, 05:06 AM
  6. [SOLVED] Open workbook that is password protected for modifying + VBA + VBS
    By uimhirADo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2012, 02:15 AM
  7. vba macro open password protected workbook
    By Ray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2006, 11:15 AM

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