+ Reply to Thread
Results 1 to 3 of 3

Dissociating buttons and text boxes from cells

  1. #1
    Registered User
    Join Date
    11-01-2018
    Location
    chicago
    MS-Off Ver
    Home and Business 2016
    Posts
    2

    Dissociating buttons and text boxes from cells

    Hello,

    I am currently creating a spreadsheet that includes buttons for macro and text boxes for instructions/explanations, and I stumbled upon an isssue.
    While running some of the macros, it will hide all useless columns of data (using EntireColumn.Hidden = True).
    I cannot predict which columns will be hidden, as it is project dependent.

    Sometimes, the buttons to run those macros are located on the columns that get hidden, meaning as soon as a macro is ran, the buttons disappear!

    Is there a way to dissociate the buttons and text boxes from the cells, so that even if the columns get hidden, the buttons and text boxes remain at the same location and visible for the user?

    Thank you!
    Last edited by antoineC; 11-01-2018 at 03:43 PM.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Dissociating buttons and text boxes from cells

    Yes. Go into design mode. Right click on object. Go to Format Control.

    Go to Properties Tab, and set it to "Move but don't size with cells".
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    11-01-2018
    Location
    chicago
    MS-Off Ver
    Home and Business 2016
    Posts
    2

    Re: Dissociating buttons and text boxes from cells

    Thank you CK76, I can't believe it was that easy!

+ 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. programming userform buttons and text boxes and drop down.
    By VShane in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-15-2018, 03:04 PM
  2. Replies: 3
    Last Post: 05-03-2016, 11:43 PM
  3. [SOLVED] Populate different text boxes using command buttons
    By Nathan_s35 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2015, 04:39 AM
  4. Copy text boxes between worksheets with buttons
    By Blueskyflyover in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-24-2013, 01:17 PM
  5. Replies: 5
    Last Post: 04-16-2011, 07:20 PM
  6. Text boxes,cursors and command buttons
    By slmi1313 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2009, 03:41 AM
  7. Replies: 4
    Last Post: 10-11-2006, 11:54 AM

Tags for this Thread

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