Results 1 to 2 of 2

CheckBox issue

Threaded View

  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    Hjørring, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    16

    CheckBox issue

    Hello

    I have a worksheet with an checkbox (CheckBox1) in cell Z6.
    what code do, is hide 3 different sheets and some columns on other sheets. Everything works perfectly.
    What I need to do now is to password protect that check box, so every time someone try to remove the mark from check box it asks for password.
    Then person that has the access to this feature, enters the correct password followed by enter. Entering the password only need to work when you want to remove the mark from check box

    Help is greatly appreciated

    Best regards
    Dedaluss

    Sub CheckBox1_Click()
            If Range("Z6").Value = True Then
            Sheets("sheet1").Select
            ActiveWindow.SelectedSheets.Visible = False
            Sheets("sheet2").Select
            ActiveWindow.SelectedSheets.Visible = False
            Sheets("sheet3").Select
            ActiveWindow.SelectedSheets.Visible = False
            Sheets("sheet4").Select
            Sheets("sheet4").Columns("S:W").Hidden = True
            Sheets("sheet5").Columns("E:F").Hidden = True
    Else
            Sheets("sheet1").Visible = True
            Sheets("sheet1").Select
            Sheets("sheet2").Visible = True
            Sheets("sheet2").Select
            Sheets("sheet3").Visible = True
            Sheets("sheet3").Select
            Sheets("sheet4").Select
            Sheets("sheet4").Columns("S:W").Hidden = False
            Sheets("sheet5").Columns("E:F").Hidden = False
        End If
    End Sub
    Last edited by Dedaluss; 03-06-2014 at 08:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] checkbox issue
    By Deepa Shrestha in forum Excel General
    Replies: 4
    Last Post: 07-24-2013, 07:41 AM
  2. [SOLVED] 2010 Excel Checkbox Issue
    By tommyfernandez in forum Excel General
    Replies: 5
    Last Post: 03-12-2013, 08:57 PM
  3. checkbox forecolor issue
    By calan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2012, 12:20 AM
  4. VBA to IE mark a checkbox (name/element issue)
    By Fargus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 01:42 PM
  5. Issue with Determining when Checkbox is Null
    By Caligula in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2007, 02:26 AM

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