+ Reply to Thread
Results 1 to 4 of 4

Protect / Unptotect Password when I run a Macro

  1. #1
    Registered User
    Join Date
    01-05-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    17

    Protect / Unptotect Password when I run a Macro

    I have the below code in my sheet and the program runs well. The problem I have is, when I choose the second criteria, the page ( Name Check ) unprotects and does not protect again... Criteria 1, works well ( Name Check - Group)

    Please help.

    Am having the code in a notepad and not posting here as I do not know how to code tag...am sorry.

    https://drive.google.com/file/d/0B14...it?usp=sharing

  2. #2
    Forum Contributor
    Join Date
    08-24-2006
    Location
    Sevenoaks, Kent
    MS-Off Ver
    Office 365 ProPlus
    Posts
    459

    Re: Protect / Unptotect Password when I run a Macro

    Place this at the top of your code
    Please Login or Register  to view this content.
    Then this at the end
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-05-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Protect / Unptotect Password when I run a Macro

    Quote Originally Posted by djfatboyfats View Post
    Place this at the top of your code
    Please Login or Register  to view this content.
    Then this at the end
    Please Login or Register  to view this content.
    Thanks. I have tried that and it works only for the 1st 'IF' criteria, and un protects for the 2nd 'IF' criteria and does not protect it back.

  4. #4
    Forum Contributor
    Join Date
    08-24-2006
    Location
    Sevenoaks, Kent
    MS-Off Ver
    Office 365 ProPlus
    Posts
    459

    Re: Protect / Unptotect Password when I run a Macro

    Do you have a sample file I can look at?

+ 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. How do I password protect a macro
    By AnnetteB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-24-2013, 10:59 AM
  2. How to protect formula & macro protect without password ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2012, 05:24 AM
  3. Password Protect Macro
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2008, 10:21 AM
  4. password protect macro
    By Modell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2006, 04:10 PM
  5. Password Protect Macro?
    By ryanmhess in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2006, 01:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1