Results 1 to 17 of 17

Protect / Unprotect Macro

Threaded View

  1. #7
    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.

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