+ Reply to Thread
Results 1 to 4 of 4

Enable/Disable a checkbox depending on the sheet where it resides.

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    Tyler, Texas
    MS-Off Ver
    Excel 2007
    Posts
    6

    Lightbulb Enable/Disable a checkbox depending on the sheet where it resides.

    I am trying to enter code that will disable (gray out) a checkbox when the sheet on which it resides is protected, and become active when the sheet is made to be unprotected (password is involved). I am working with Excel 2007. I'm new to VBA.
    Last edited by MontySmall; 05-30-2013 at 10:58 PM.

  2. #2
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 2010
    Posts
    693

    Re: Enable/Disable a checkbox depending on the sheet where it resides.

    Hi MontySmall,

    WELCOME TO THE FORUM!

    Try below code and refer attached workbook (password is involved).

    Don't forget to set thread SOLVED and click *

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers,

    Joshi
    Being with a winner makes you a winner

  3. #3
    Registered User
    Join Date
    05-30-2013
    Location
    Tyler, Texas
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Enable/Disable a checkbox depending on the sheet where it resides.

    Joshi,
    Thanks a million!
    MontySmall

  4. #4
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 2010
    Posts
    693

    Re: Enable/Disable a checkbox depending on the sheet where it resides.

    Hi MontySmall,

    You are welcome. Glad I could help. If the code is ok, please mark the post as SOLVED

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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