+ Reply to Thread
Results 1 to 5 of 5

Hide Form Button ?

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,470

    Hide Form Button ?

    I thought this was gonna be a slam / dunk ... but nooooooo .....

    I have a Form button on Sheet 1. (Not ActiveX ... a Form Button)

    When the workbook loads, a wave file is auto played.

    I want the button to be hidden until the wav file finishes playing.

    I have spent 6 hours searching the internet and found all kinds of 'examples' how to hide the button but .... either
    an error message says 'Object doesn't support that.' or the macro is completely ignored and nothing happens to the button.

    How can so many folks be wrong about hiding a button on a worksheet ?

    Do you have a SURE FIRE way of hiding then unhiding the button ?

  2. #2
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    91

    Re: Hide Form Button ?

    ActiveSheet.Shapes.Range(Array("Button 1")).Visible = False

    I tried it on a sheet and it worked

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,470

    Re: Hide Form Button ?

    Thank you so much !

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,470

    Re: Hide Form Button ?

    It's been a sloooooow Friday nite.

    Had to do something !
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    91

    Re: Hide Form Button ?

    Gotta love Precious! LOL

+ 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. Replies: 1
    Last Post: 02-27-2017, 09:17 AM
  2. VBA to hide or disable a form control button based on cell value
    By npsnps in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-11-2017, 06:40 AM
  3. [SOLVED] I want a form button to disappear when I hide the column that it is sitting in, how?
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2014, 06:43 PM
  4. Hide a picture button placed in all sheets using a option button (form control)
    By lagaranch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-26-2012, 10:33 AM
  5. [SOLVED] Hide/unhide a form button based upon a data validation value
    By w8itn4you in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2012, 09:00 PM
  6. [SOLVED] Hide Command Button On Form
    By alyon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2012, 12:04 PM
  7. Hide form button or rectangle based on cell value
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-14-2009, 10:58 AM

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