Results 1 to 7 of 7

[SOLVED]VBA - Button(Form Control)-Disable/Enable->Alternate Solution

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)-Disable/Enable->Alternate Solution

    I have a FORM CONTROL in my worksheet.

    Example:

    I have (3) Buttons (Form Control) in Sheet1, each buttons have macro on it when they've been click.

    The problem is I want to DISABLE the functionality of the (3) Buttons when the user click it.

    Named:
    btn1
    btn2
    btn3

    NOTE:

    Developer tab -> Insert -> Buttons (Form Control)

    Attachment:
    SampleWorksheet.xlsb
    Last edited by mcmunoz; 09-20-2013 at 02:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Button Enable and Disable
    By excel_student_98 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2013, 05:34 AM
  2. [SOLVED] Button enable and disable...
    By Will03 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2013, 10:00 AM
  3. Enable/Disable Form controls on a worksheet (not Active X Control)
    By vaniravi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2012, 07:42 AM
  4. [SOLVED] Enable/Disable Command Button
    By rain4uu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-06-2012, 03:27 AM
  5. [SOLVED]Enable and disable button
    By blues_oo7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2010, 06:45 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