+ Reply to Thread
Results 1 to 5 of 5

hide unhide button depending on cell value

  1. #1
    Registered User
    Join Date
    01-10-2012
    Location
    Aruba
    MS-Off Ver
    Excel 2007
    Posts
    48

    hide unhide button depending on cell value

    Hi you'll

    I have a workbook for teachers to fill out grades for their students. The main sheet has all the names and subjets. The rest of the sheets are named by the cells which have the names of the students and the subjects in it (every student and every subject has its own sheet) . This is done by a calculate event. These sheets are veryhidden when no student/subject name is entered. On the main sheet I have buttons (from forms control) that, when clicked, go to the sheet from that student. I have been looking for some code that hides the button when no name is entered (no name means sheet hidden, means when button clicked error pops up since the sheet is hidden) and to unhide when a name is entered.
    Thanks in advance for any help offered.
    MarcoAUA
    Last edited by MarcoAUA; 02-25-2012 at 09:33 PM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: hide unhide button depending on cell value

    Do you have a sample sheet that you can attach?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    01-10-2012
    Location
    Aruba
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: hide unhide button depending on cell value

    Thank you for the time and response!
    See attachment.
    There is still a lot of work to be done in the sheets (copy grades to the students sheets for instance) but it is about the button.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-10-2012
    Location
    Aruba
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: hide unhide button depending on cell value

    Please Login or Register  to view this content.
    I have found some code that should hide unhide the button, but it doesn't...
    Any ideas concerning this?
    THNX

  5. #5
    Registered User
    Join Date
    01-10-2012
    Location
    Aruba
    MS-Off Ver
    Excel 2007
    Posts
    48

    Thumbs up Re: hide unhide button depending on cell value

    Please Login or Register  to view this content.
    After more browsing I found this code (courtesy to Dave Hawley) and it works.
    THNX for the time and effort.

    MarcoAUA

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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