+ Reply to Thread
Results 1 to 17 of 17

Protect / Unprotect Macro

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Protect / Unprotect Macro

    Good job on getting this far. Here is the modified code. We try to keep these forums organised and easy to read, so can you please go back to your first post and wrap your VBA code in the code tags. Click "go advanced", highlight the code, and then click the # button.

    Now that you have this, see if you can work out how to change the Title of the userform so that it reads "Enter Password to Protect" or "Enter Password to Unprotect" or something similar.

    EDIT: You could also change the the button label to toggle between "sheet is protected, click to unprotect" and "Click to protect sheet"
    Attached Files Attached Files
    Last edited by Mallycat; 04-21-2012 at 07:21 PM.

  2. #2
    Forum Contributor jason.hampton's Avatar
    Join Date
    04-20-2012
    Location
    Republic of Texas
    MS-Off Ver
    2007, 2010, 2016
    Posts
    138

    Re: Protect / Unprotect Macro

    Mallycat,

    Thanks for your assistance! This works great. I figured out how to change the title. But don't know how to make it toggle between protect and unprotect windows. I don't have a tremendous amount of VBS experience. Any asssistance will be appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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