Results 11 to 12 of 12

Thread: Protect Or Unprotect Sheet Only If Password Matches

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-05-2013, 06:01 PM #1
    raybugge
    raybugge is offline
    Junior Member
    Join Date
    Jun 2013
    Posts
    16
    Rep Power
    0

    Protect Or Unprotect Sheet Only If Password Matches

    I`m in need of a code to protect and un-protect 2 sheets in a workbook.In the Activity Sheet I want the sheet protected except for the cells highlighted Green.These cell ranges are always available for editing so no protection needed.
    In the Progress sheet I want this whole sheet protected unless the Un-Protect button activated
    I will use a button on each sheet so as I can Protect or Unprotect each sheet individually....can these 2 individual buttons have password requirements
    Thanks
    Ray
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Code To Protect Sheet With Only A Few Cells Unlocked
    By rich_cirillo in forum Excel Help
    Replies: 3
    Last Post: 07-04-2013, 06:47 PM
  2. How do I get Vlookup to return multiple matches?
    By HANOOF in forum Excel Help
    Replies: 1
    Last Post: 06-04-2013, 10:06 PM
  3. Macro to copy data where name matches destination workbook
    By Howardc in forum Excel Help
    Replies: 0
    Last Post: 04-20-2013, 10:07 AM
  4. Password Holder
    By littleiitin in forum Download Center
    Replies: 3
    Last Post: 01-01-2013, 03:22 PM
  5. CheckBox to see password
    By Ingolf in forum Excel Help
    Replies: 9
    Last Post: 08-26-2012, 11:56 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
  •  

Forum Rules