+ Reply to Thread
Results 1 to 6 of 6

Hide/Unhide Toggle Buttons

  1. #1
    Registered User
    Join Date
    12-20-2019
    Location
    South Dakota
    MS-Off Ver
    365
    Posts
    56

    Hide/Unhide Toggle Buttons

    Can a toggle button be coded to hide/unhide other toggle buttons? Not by hiding rows containing the buttons though.

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,466

    Re: Hide/Unhide Toggle Buttons

    Sure. Assuming ToggleButton1 is to toggle the visibility of ToggleButton2, ToggleButton3 and ToggleButton4...
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-20-2019
    Location
    South Dakota
    MS-Off Ver
    365
    Posts
    56

    Re: Hide/Unhide Toggle Buttons

    Initially it did it backwards, when I clicked the button the other buttons disappeared.
    So I had to make the buttons visible, delete this code, click the button, insert the code, then click the button again.
    But, when I reopened the sheet the buttons all started off as visible - I clicked the button which activated other functions and left the other buttons visible - then clicked the button again which properly hid the other buttons.

    Playing around with it with a different code, not sure if it works any better:
    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,466

    Re: Hide/Unhide Toggle Buttons

    Quote Originally Posted by hk57 View Post
    Initially it did it backwards, when I clicked the button the other buttons disappeared.
    Isn't that what "toggle" means? If the buttons are visible and you click the toggle button, they disappear... click it again and they reappear. I guess I am confused... why would you click a button to make visible buttons visible?

  5. #5
    Registered User
    Join Date
    12-20-2019
    Location
    South Dakota
    MS-Off Ver
    365
    Posts
    56

    Re: Hide/Unhide Toggle Buttons

    I want the buttons to be hidden until I click the button. But it doesn't allow the code
    Please Login or Register  to view this content.

  6. #6
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,466

    Re: Hide/Unhide Toggle Buttons

    Quote Originally Posted by hk57 View Post
    I want the buttons to be hidden until I click the button.
    If you want the ToggleButton to be hidden initially, go into Design Mode (on the Developer Tab), then right click the ToggleButton, select Properties from the popup menu that appears and then set the Visible property to False.

    If you want to do this in code, the correct statement is...
    Please Login or Register  to view this content.

+ 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. [SOLVED] Toggle Hide/Unhide Cols & Toggle adj column width
    By anare in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-20-2018, 11:04 AM
  2. toggle hide unhide rows, vba code
    By annazet in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-18-2017, 03:06 PM
  3. Toggle Button to hide unhide sheets
    By 95marine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2017, 04:46 PM
  4. [SOLVED] hide/unhide a range toggle
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2016, 03:54 PM
  5. Macro to toggle between Hide and Unhide rows
    By fpt264 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-14-2013, 01:47 PM
  6. macro - toggle hide/unhide row
    By taken in forum Excel Programming / VBA / Macros
    Replies: 72
    Last Post: 04-13-2013, 10:04 AM
  7. Hide row if cell is a certain value, with unhide toggle option
    By stir-crazy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2008, 09:16 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