+ Reply to Thread
Results 1 to 2 of 2

How to Hide/Unhide Command Buttons along with Columns

Hybrid View

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    Southwest Florida
    MS-Off Ver
    Excel 2007
    Posts
    14

    How to Hide/Unhide Command Buttons along with Columns

    I have 5 columns that are Grouped together. Each column has three ActiveX, command buttons. I would like to have the command buttons collapse and expand with the columns as the column Group is collapsed and expanded. When I tried this, some of the command buttons do this, but some don't.

    To clarify... the buttons collapse, however, they collapse on top of each other and are still visible.
    Last edited by EddieN1; 07-24-2013 at 09:48 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,286

    Re: How to Hide/Unhide Command Buttons along with Columns

    You need to select Format Control ... | Properties tab for each of the buttons and choose "move and size with cells".


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. How to add hide/unhide buttons in Excel 2010 sidebar
    By JakiGee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2013, 08:01 AM
  2. VBA buttons for hide/unhide rows disappear at random
    By derekopswat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2013, 01:10 PM
  3. [SOLVED] Buttons need to hide/unhide along with columns
    By rowlandjp in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-28-2012, 03:29 PM
  4. Displaced control buttons after hide unhide
    By reinkonemann in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2011, 10:36 AM
  5. I am missing something (hide / unhide rows with buttons)
    By Turquoise_dax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2006, 01:01 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