Results 1 to 6 of 6

Conditionally Hide or deactivate code in an activeX command Button.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Conditionally Hide or deactivate code in an activeX command Button.

    I have a workbook with multiple sheets, the sheets will be labels 18.08.14 , 25.08.14 etc.

    I have an activex Command button that will once pressed run code to send a section of the sheet as an email to a group of people. I need to disable this button when we're no longer in this period. i.e. if todays date is greater greater than 7 days from the sheet name either disable or hide the button.

    Thank you for any advice or help, in advance.
    Last edited by Kramxel; 08-26-2014 at 07:36 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 06-18-2014, 02:25 PM
  2. Hide or deactivate a ribbon button
    By Zer0aim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2013, 05:51 AM
  3. Run activex command button via macro
    By dhaval123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2013, 06:07 AM
  4. ActiveX Command Button Text Looks Bad
    By brownsl in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-07-2012, 07:35 AM
  5. ActiveX command button
    By Dr.Schwartz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2005, 04:05 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