+ Reply to Thread
Results 1 to 3 of 3

VBA code that bypass Password prompt for every workbook with one master password

  1. #1
    Registered User
    Join Date
    06-30-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    70

    VBA code that bypass Password prompt for every workbook with one master password

    Hi...

    I hv one query...

    I gave every workbook one same password and send it to my client. But I don't want that when ever i open that file it will not ask me the password. So is their any vba code which consist my master password and when i open that workbook it will automatically gave it and directly open that file for me...... ???

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: VBA code that bypass Password prompt for every workbook with one master password

    Hi,

    This code will loop through your workbook, and unprotect each sheet, provided they all have the same password. Just enter that password where indicated by red text

    Please Login or Register  to view this content.
    Hope this helps, please let me know!

    Regards,

    David


    When you reply please make it clear WHO you are responding to by mentioning their name.

    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,019

    Re: VBA code that bypass Password prompt for every workbook with one master password

    Hi, pwnyadav007,

    from what I read you would need to create a workbook from which you open the other workbooks (or use the personla macro workbook or an addin). This WB should offer a dialogue/GetOpenFilename to choose the workbook and pass the parameter of the password when opening the workbook.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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. Save Active workbook, Add a password via a prompt and stop creating backups
    By dlast in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2013, 05:59 AM
  2. How to bypass password prompt and open workbook in read only mode.
    By Tazyote in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2012, 05:04 AM
  3. Bypass username/password prompt when executing an excel web query
    By Richard Flame in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2007, 01:20 PM
  4. how to bypass password??
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2006, 05:50 PM
  5. Replies: 1
    Last Post: 02-07-2005, 08:06 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