3x Checkboxes - Hide/Unhide sheet
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: 3x Checkboxes - Hide/Unhide sheet

  1. #11
    Board Regular
    Join Date
    Jul 2018
    Location
    Auckland
    Posts
    260
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 3x Checkboxes - Hide/Unhide sheet

    Yes, I copied your code and replaced it.
    It works if "G2" is Unprotected and "Beef" is Protected, but it won't work if both sheets are Protected.

  2. #12
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,231
    Post Thanks / Like
    Mentioned
    49 Post(s)
    Tagged
    14 Thread(s)

    Default Re: 3x Checkboxes - Hide/Unhide sheet

    Quote Originally Posted by tlc53 View Post
    Yes, I copied your code and replaced it.
    It works if "G2" is Unprotected and "Beef" is Protected, but it won't work if both sheets are Protected.
    Try this

    Code:
    Sub Beef()
        activesheet.Unprotect
        Sheets("Beef").Unprotect
        Sheets("Beef").Visible = False
        If [Q1] Then Sheets("Beef").Visible = True
        Sheets("Beef").Protect
        activesheet.Protect
    End Sub
    Regards Dante Amor

  3. #13
    Board Regular
    Join Date
    Jul 2018
    Location
    Auckland
    Posts
    260
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 3x Checkboxes - Hide/Unhide sheet

    Thanks. I would expect that to work too. No idea why it's not

    I've created a link to the spreadsheet. Any chance you could have a look please? All sheets except G2 are Protected with no password and the original coding is currently in there.

    https://www.dropbox.com/s/o35w2mb4o2...tion.xlsm?dl=0

  4. #14
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,231
    Post Thanks / Like
    Mentioned
    49 Post(s)
    Tagged
    14 Thread(s)

    Default Re: 3x Checkboxes - Hide/Unhide sheet

    Sorry, but I do not understand.
    You can tell step-by-step what to do in your file and what you expect in each step.
    Regards Dante Amor

  5. #15
    Board Regular
    Join Date
    Jul 2018
    Location
    Auckland
    Posts
    260
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 3x Checkboxes - Hide/Unhide sheet

    Thank you, all sorted now.
    It was me being a dope! Cell Q1 was locked

  6. #16
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,231
    Post Thanks / Like
    Mentioned
    49 Post(s)
    Tagged
    14 Thread(s)

    Default Re: 3x Checkboxes - Hide/Unhide sheet

    Quote Originally Posted by tlc53 View Post
    Thank you, all sorted now.
    It was me being a dope! Cell Q1 was locked
    Youre welcome
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •