Results 1 to 5 of 5

hide unhide button depending on cell value

Threaded View

MarcoAUA hide unhide button depending... 02-25-2012, 12:55 PM
arlu1201 Re: hide unhide button... 02-25-2012, 01:56 PM
MarcoAUA Re: hide unhide button... 02-25-2012, 02:29 PM
MarcoAUA Re: hide unhide button... 02-25-2012, 03:56 PM
MarcoAUA Re: hide unhide button... 02-25-2012, 09:29 PM
  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.

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