+ Reply to Thread
Results 1 to 7 of 7

Howto keep ActiveX Toggle buttons visible, even when columns are hided

  1. #1
    Registered User
    Join Date
    03-28-2020
    Location
    Flevoland
    MS-Off Ver
    360
    Posts
    15

    Howto keep ActiveX Toggle buttons visible, even when columns are hided

    Hi,

    Is there a way to keep ActiveX Toggle buttons visible even when you hide the columns where you put them?

    John
    Last edited by jdo358; 03-29-2020 at 06:01 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Howto keep ActiveX Toggle buttons visible, even when columns are hided

    When I hide a column where an ActiveX toggle button is located, the button stays visible. Can you describe in detail what steps you take that lead the button to become invisible?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Howto keep ActiveX Toggle buttons visible, even when columns are hided

    Move and size with cell property of object must be switched to don't move and size.

  4. #4
    Registered User
    Join Date
    03-28-2020
    Location
    Flevoland
    MS-Off Ver
    360
    Posts
    15

    Re: Howto keep ActiveX Toggle buttons visible, even when columns are hided

    Well, it's not that complicated.. . I created three Togglebuttons, and put them in the left top corner of my sheet (cell B1 / C1). Columns B and C are locked. When I hide these columns, only the right togglebutton will stay visible. The other buttons are hided with the column. I compared the properties of the button staying visible with the other buttons, but didn't find a difference.

  5. #5
    Registered User
    Join Date
    03-28-2020
    Location
    Flevoland
    MS-Off Ver
    360
    Posts
    15

    Re: Howto keep ActiveX Toggle buttons visible, even when columns are hided

    Hm.. can't find these attributes in the toggle button properties. I'm quite new to Excel VBA so can you a bit more specific please?

  6. #6
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Howto keep ActiveX Toggle buttons visible, even when columns are hided


  7. #7
    Registered User
    Join Date
    03-28-2020
    Location
    Flevoland
    MS-Off Ver
    360
    Posts
    15

    Re: Howto keep ActiveX Toggle buttons visible, even when columns are hided

    Quote Originally Posted by BMV View Post
    Thank you very much BMW!! Thats what I was looking for. I checked the Toggle button properties and couldn't find what you said, instead of the Object properties. Sorry for the confusion. I will put this thread to solved.

+ 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] Change properties of multiple activex buttons in 3 columns with a loop and an array
    By boardy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-27-2020, 06:31 PM
  2. Can Toggle Buttons control other multiple Toggle Buttons
    By Slurry Pumper in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-09-2018, 08:22 AM
  3. [SOLVED] how do i make a toggle button change other toggle buttons value to false
    By kevinu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-10-2018, 04:19 PM
  4. Howto Copy/Paste Visible Only, Multi-Range, from Sheet1 to Sheet2
    By Aaeijh in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-13-2018, 02:28 PM
  5. [SOLVED] ActiveX Toggle Button - Only ONE at a time
    By ericbartha in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-24-2014, 03:23 PM
  6. [SOLVED] Looking for help tidying up Macro vba code / visible/non visible buttons
    By darrenkaye in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-03-2012, 11:50 AM
  7. How to make ActiveX Toggle Buttons mutually exclusive
    By gazza365 in forum Excel General
    Replies: 1
    Last Post: 01-19-2011, 10:18 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