Results 1 to 3 of 3

[SOLVED] VBA - Button (Form Control) - Visible = True/False

Threaded View

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    Quezon City
    MS-Off Ver
    Excel 2010 and 2013
    Posts
    75

    [SOLVED] VBA - Button (Form Control) - Visible = True/False

    My macro HIDES ALL of the BUTTONS.

    I want all button named starting "btn*" will be Visible = False except this vbtnVisibleButtons button.

    Sheet1
    -> btnReset
    -> btnAdd
    -> btnDelete
    -> btnClear

    -> vbtnVisibleButtons - code

    Previous Code:

    Sub sample()
    Dim btn
    
    For Each btn In ActiveSheet.Shapes
     
    btn.Visible = False
    
    Next btn
    
    End Sub
    Note: DEVELOPER tab -> INSERT -> Button (Form Control)
    Last edited by mcmunoz; 09-23-2013 at 01:46 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to make textbox visible true/false
    By fremarco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2012, 11:40 PM
  2. ActveX Control Button Not Working But Form Control Button is
    By MikeTruth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 05:04 AM
  3. Command Button True/False States
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2011, 06:08 PM
  4. Replies: 7
    Last Post: 06-27-2007, 08:39 AM
  5. Shapes.visible = false/true
    By Ctech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2006, 10:30 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