+ Reply to Thread
Results 1 to 4 of 4

Enable and disable command button s

  1. 03-19-2019, 06:08 AM #1
    grkchakri
    grkchakri is offline
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Enable and disable command button s

    Hi all
    I have sheet where I have 3 command buttons. I want 2 buttons to be in disabled state until when I click the 3 button

    My query is how to make these command buttons disabled when the operator opens the workbook.
    Suggestions please
    Reply With QuoteRegister To Reply
  2. 03-19-2019, 06:51 AM #2
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Enable and disable command button s

    Place the first code in the "ThisWorkbook" module
    NB:- Code relates to sheet2!!!
    NB:-See Project list to left of Code Window.

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 04-26-2019, 12:39 AM #3
    grkchakri
    grkchakri is offline
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Re: Enable and disable command button s

    At the outset Apologies was too late in coming back to you Mick. thank you very much for the help. it worked brilliant
    Never confuse a single defeat to the final defeat.
    Reply With QuoteRegister To Reply
  4. 04-26-2019, 06:14 AM #4
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Enable and disable command button s

    You're welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Disable and Enable Command Button via checkbox
    By Omkokane in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2018, 11:24 PM
  2. Disable and Enable a Command Button on a Dynamically Changing Multipage Userform
    By whazzup_billy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2017, 10:43 PM
  3. Enable/disable a command button
    By rajeev.raj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2016, 05:06 AM
  4. [SOLVED] Disable a command button yet enable it based on other conditions
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 12-23-2015, 08:37 AM
  5. [SOLVED] Disable/Enable command button in Excel sheet
    By luneke1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2014, 12:51 AM
  6. enable/disable a command button in User Form w/ condition
    By Bidyut Chakraborty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2014, 03:11 AM
  7. [SOLVED] Enable/Disable Command Button
    By rain4uu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-06-2012, 03:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1