+ Reply to Thread
Results 1 to 2 of 2

Option/Check box issue

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Option/Check box issue

    I have one issue with check/option buttons and a second question relating to the use of option buttons to remove cells.

    Question 1:
    SOLVED

    Question 2: I have data entry areas on a sheet that aren't required when undertaking certain activities. I want to set up an option button for the choices of activities and when a certain activity is selected the cells that are not required for this activity are removed or hidden.
    Last edited by lockers; 06-13-2013 at 11:55 PM.

  2. #2
    Forum Contributor
    Join Date
    09-22-2012
    Location
    Berkeley, CA
    MS-Off Ver
    Excel 2010
    Posts
    112

    Re: Option/Check box issue

    I would have the sheet change the background color to grey or whatever color you like and lock the cell so it can't be edited.
    Attached Files Attached Files
    ------------------------
    W2

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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