+ Reply to Thread
Results 1 to 3 of 3

protect each sheet with different password

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    61

    protect each sheet with different password

    I have say 10 sheets in the workbook
    and I have created a table listing all 10 names of the respective worksheet in column A and each password for each of the respective sheets in column B.

    I need the macro to protect each of the sheets based on the password i have listed in the table respectively.

    I kept getting object failed error with the codes i have written below.

    Please help.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-10-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: protect each sheet with different password

    Attached here is my sample file. It keeps giving me error and it locks with the formula not the result of formula.


    If you tried and it locks, you may just run the password breaker code to unprotect it.
    Attached Files Attached Files
    Last edited by boon-yao.tek; 05-08-2015 at 01:40 AM.

  3. #3
    Registered User
    Join Date
    09-10-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: protect each sheet with different password

    Please help to tweak my sample file... the sample file is not working correctly.

+ 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] Protect a sheet with a password, but secure the password
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2013, 01:59 AM
  2. Protect sheet with 2 or more password
    By iazis in forum Excel General
    Replies: 3
    Last Post: 05-02-2012, 07:07 AM
  3. Protect Sheet & Password Protect Code
    By KLahvic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-13-2009, 04:08 PM
  4. Password protect 1 sheet
    By LarryC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-03-2008, 11:08 AM
  5. password protect sheet
    By philbennison in forum Excel General
    Replies: 7
    Last Post: 11-29-2007, 06:56 PM

Tags for this Thread

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