+ Reply to Thread
Results 1 to 4 of 4

Disabling buttons via Sub

  1. #1
    Registered User
    Join Date
    08-21-2014
    Location
    Frankfurt
    MS-Off Ver
    2007
    Posts
    4

    Disabling buttons via Sub

    Hello!

    I wrote following sub to disable a button

    Please Login or Register  to view this content.
    Then somewhere else in a different sub
    Please Login or Register  to view this content.
    I tried countless variations of parameters and stuff, but I cant get it to work. How do I call the disablebutton sub correctly?

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Disabling buttons via Sub

    Hi jack...
    you have nowhere given any reference to the command button..

    Try this..
    hopefully this will do..

    Please Login or Register  to view this content.
    AND

    Please Login or Register  to view this content.
    me or userform..
    Last edited by JBeaucaire; 08-29-2014 at 12:01 PM.

  3. #3
    Registered User
    Join Date
    08-21-2014
    Location
    Frankfurt
    MS-Off Ver
    2007
    Posts
    4

    Re: Disabling buttons via Sub

    jup that was it, thank you very much!

  4. #4
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Disabling buttons via Sub

    Hi,

    Check the below code and hope this will help you:

    Please Login or Register  to view this content.

    Where, parameter "1" in disable_button is for Commandbutton1 and so on.

    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

+ 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. [SOLVED] Automatic disabling of Option buttons based on current date.
    By raj.bris in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-19-2013, 02:29 AM
  2. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM
  3. Enabling and disabling buttons depending on amount of worksheets.
    By tombe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2008, 08:59 PM
  4. Enabling/Disabling a Series of Macros Buttons
    By justincade in forum Excel General
    Replies: 5
    Last Post: 02-05-2007, 04:38 PM
  5. disabling custom buttons during cell edit mode
    By Doug Glancy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2005, 12:55 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