Results 1 to 20 of 20

hiding rows which contain checkboxes but checkboxes don't hide as they should

Threaded View

  1. #20
    Registered User
    Join Date
    08-07-2019
    Location
    Chile
    MS-Off Ver
    365
    Posts
    8

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Hi,

    I am new to this forum and I don't know where I can ask my question, that's why I do it here, since it has to do with what they were talking about.

    I have a problem with the code they put to show the Checkboxes after they were hidden.

    This is the code that gives me problems.

    Sub UnHideColumns ()

    Columns ("D: AL"). EntireColumn.Hidden = False

    ActiveSheet.CheckBoxes.Visible = True

    End Sub



    when I run it, it shows me the boxes on the form, but I get an error message that says:

    << There was an error "1004" at runtime:

    The visible property of the CheckBoxes class cannot be assigned. >>

    Thank you very much for your help!

    I also leave the file in case they need it.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help Needed with Checkboxes to Hide or Unhide Rows
    By dgibney in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-25-2014, 11:39 AM
  2. [SOLVED] Hide/unhide rows with checkboxes
    By mixer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2014, 03:58 PM
  3. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  4. [SOLVED] Automatically Hiding rows based on checkboxes
    By Jake Bierly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2012, 06:08 PM
  5. Hide rows AND checkboxes in that row with code/macro
    By Riqueza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 05:38 AM
  6. Hiding rows, but checkboxes aren't hidden
    By kid_epicurus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2012, 02:46 PM
  7. Hiding and Unhiding a Dynamic Range of Rows Using Checkboxes
    By markymark84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2012, 11:51 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