+ Reply to Thread
Results 1 to 3 of 3

Unprotect Workbook Enter Password One Time

  1. #1
    Forum Contributor
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    421

    Unprotect Workbook Enter Password One Time

    Hello,

    I have this code to unprotect worksheets but it asks for the password more than one time. How can it only ask for the password one time to unprotect all worksheets?

    Thanks,
    Fred

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Unprotect Workbook Enter Password One Time

    Here, within your module, you have the InputBox twice. Remove the second inputbox that should fix the issue. I fixed your code a little.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    421

    Re: Unprotect Workbook Enter Password One Time

    Thank you so much I missed that detail.


+ 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. [SOLVED] Unprotect & Protect All workbook sheets password protection / existing code help needed
    By annazet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2017, 04:51 PM
  2. [SOLVED] Error on password unprotect macro upon workbook open event
    By phpolicylady in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2015, 02:00 PM
  3. Replies: 0
    Last Post: 03-12-2013, 02:33 AM
  4. Excel 2010 VBA unprotect password - run time error 424 Object required
    By wov in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2012, 01:35 AM
  5. How to unprotect a workbook if the password is lost
    By CantripGhost in forum Excel General
    Replies: 2
    Last Post: 12-21-2010, 09:50 AM
  6. [SOLVED] Record a macro which enters a password to unprotect a workbook
    By Zeon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2006, 03:25 PM
  7. [SOLVED] Unprotect workbook without password
    By Maria K Brickl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2005, 02:05 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