+ Reply to Thread
Results 1 to 10 of 10

password protecting tabs

  1. 06-11-2020, 11:26 AM #1
    Jbelle7435
    Jbelle7435 is offline
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    72

    password protecting tabs

    I was up last last night with an excel spread sheet with alot of tabs for my job. Let's say 20~30. I setup each one to allow outside users to enter in information to the unlocked cells. My gripe was having to password protect each sheet one by one for 20~30 times. I see there is the protect WORKBOOK option but it suggest moving, deleting, and adding sheets and not focusing on my locked cells in each sheet. Maybe you can use Protect workbook to solve my problem. If not is there a better way than submitting a password for each tab which is tedious work that people out there love to remove from people like my lives on the daily basis

    Cheers.

    PB
    Last edited by Jbelle7435; 06-11-2020 at 03:03 PM.
    Reply With QuoteRegister To Reply
  2. 06-11-2020, 11:37 AM #2
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: password protecting tabs

    .
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 06-11-2020, 11:46 AM #3
    Jbelle7435
    Jbelle7435 is offline
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    72

    Re: password protecting tabs

    macros. Are you friggin crazy. Ok I'll test it out. What is the worst that can happen.
    Reply With QuoteRegister To Reply
  4. 06-11-2020, 11:54 AM #4
    Jbelle7435
    Jbelle7435 is offline
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    72

    Re: password protecting tabs

    password is the password. Thanks Logit I'm loving it. One stop shop and then unprotect as I go along. Best part is also I can copy the Password protected sheets to new sheets and maintain the protection as such.

    Because we're on topic and extra credit is it even possible to reverse it all with one typical Password request box comes Up and takes care of un-protecting all the tabs back to square one?
    after I will close this thread out!!!!
    Reply With QuoteRegister To Reply
  5. 06-11-2020, 12:24 PM #5
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: password protecting tabs

    .
    Google unprotect all sheets
    Reply With QuoteRegister To Reply
  6. 06-11-2020, 12:52 PM #6
    Jbelle7435
    Jbelle7435 is offline
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    72

    Re: password protecting tabs

    I did but still want that password protection. Simple ones do not hence anyone can unprotect it. I'll wrap this up soon but thanks still.
    Reply With QuoteRegister To Reply
  7. 06-11-2020, 01:53 PM #7
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: password protecting tabs

    .
    If you want to be the only one who can activate / deactivate the password .... password one sheet with a unique password from all the rest.
    Then in the sheet you can have buttons that protect or unprotect the workbook.

    There are also working samples on the Forum and the internet where you click a single button on the OPENING sheet. That brings up an
    INPUT BOX where you enter a password. That password can unprotect all the sheets desired. You can create a separate button on the
    OPENING sheet that brings up an INPUT box that asks for a password to protect all the sheets.
    Reply With QuoteRegister To Reply
  8. 06-11-2020, 02:21 PM #8
    Jbelle7435
    Jbelle7435 is offline
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    72

    Re: password protecting tabs

    Time to close this thread:

    1. I thank Logit
    2. I thank google
    3. I thank https://www.extendoffice.com/documen...s-at-once.html for the protect updated code and a user on their forum[N1ckole · 5 years ago] that had a good unprotect code to wrap this all up!

    Please Login or Register  to view this content.
    Last edited by Jbelle7435; 06-11-2020 at 02:23 PM.
    Reply With QuoteRegister To Reply
  9. 06-11-2020, 02:56 PM #9
    Jbelle7435
    Jbelle7435 is offline
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    72

    Re: password protecting tabs

    https://www.excelforum.com/non-engli...as-solved.html

    my step 2 I don't see "go advance" to close the thread??

    when I hit reply I see go advance but still no closing options appear

    ohhhhh. Found it. No need to hit the advance button. Pre-fix was there. You excel forummmmmm peeps you!

    Thanks,

    until the next thread,

    Peace
    Last edited by Jbelle7435; 06-11-2020 at 03:02 PM.
    Reply With QuoteRegister To Reply
  10. 06-11-2020, 03:17 PM #10
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: password protecting tabs

    .
    Glad you found the answer !!

    Cheers
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Password Protecting
    By snikrs in forum Excel General
    Replies: 2
    Last Post: 12-13-2018, 02:52 PM
  2. [SOLVED] Password Protecting VBA
    By SaleenaKhan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2013, 02:00 AM
  3. Protecting tabs and protecting sheets
    By jimstrongy in forum Excel General
    Replies: 0
    Last Post: 01-31-2012, 11:27 AM
  4. Password protecting individual tabs in Excel 2003
    By WeatherMan in forum Excel General
    Replies: 3
    Last Post: 06-27-2008, 08:00 AM
  5. Password Protecting
    By awormofearth in forum Excel General
    Replies: 2
    Last Post: 09-13-2007, 05:19 PM
  6. Password Protecting a particular Sub
    By pianoman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2006, 04:06 AM
  7. [SOLVED] Password Protecting
    By Nick in forum Excel General
    Replies: 6
    Last Post: 06-30-2005, 08:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1