hiding cell content until a click action

**excel77** · 11-06-2008, 12:05 PM

Please someone help me here, my boss designed this table for training needs of our department. its is a spreadsheet of training courses versus dates and names are inserted into the cells. he also made a legends of all the names in the department.

what he wants is the names to be hidden on the spreadsheet until he click on individual name in the legend, then only that name appears on the spreadsheet against any training selected for that person.

hope you understand this.

i need a solution to this. some one help!!!!

**JBeaucaire** · 11-06-2008, 12:19 PM

Post a sample workbook so we can see what you're trying to do. In the sample show how it should look before and after. Several lines makes it clear.

**MickG** · 11-06-2008, 12:38 PM

Hi, This is an eample that you can, Perhaps modify.
If your names (The ones to Hide) are in column ("E") and you Legend names are in column "A".
Then, using this code when you select a name in column "A" all the text in column "E" changes to "white" so you won't see the names,
unless you have the background colour a different colour.
When you select a name in column "A" that name in column "E" will have its font colour changed Back to Black.
To enter the code.
Right click the sheet tab, Select "View Code". Paste the entire code into the VB Editor window.
The code will run when you Select any cell in column "A"

Please Login or Register  to view this content.

REgards Mick

**excel77** · 11-06-2008, 07:32 PM

thanks Mick for your quick responds. i ran the code and it worked the way you said. this is a way forward. however the names are [the ones to hide] are in different columns with different background colours. and the names [the ones in the legend ] are in a column under the table, so this shares a column with the table.

**excel77** · 11-06-2008, 08:01 PM

Hi Mick,
i have gotten a way round the background colours by changing the colour numbers in the code.
please how can i make this code cover a range of colums , say from column E to M.

**MickG** · 11-07-2008, 11:17 AM

Hi, Do you mean you want to hide all details in columns "E to M" until you select a name from the Legend, when on selection the Name and its row (within range)are shown.
If this is what you want, what column within this range "E to M" are your names in.
(i.e. Those Names that relate to the legend names).
Also What range is the Legend in ??
Regards Mick

**excel77** · 11-11-2008, 03:50 AM

please find attached is the spreedsheet and the much i have done.

the names in the legend [columnA] when clicked appears only on the spreadsheet. and the button [All Staff] when clicked shows the names of all the staff.

the next step is;
1; if a name is clicked from column 1, [and all cells with that name should then show the name], for a particular year [ability to select a year should then be imbedded] the status column should show a N -for NO or Y-for Yes. if a Y then all the Duration associated with the Y should be added up into a cell at the bottom of the sheet. if N then
2; if N then the course should appear in the second spreadsheet [DNA] attached.

3; due to the first spreadsheet being very large, printing is a problem. therefore if a person is selected from column A, for a particular year a print format should be created with all empty cells in column I, N S, X and AC be removed with every other column retained in single cells so printing can be in a page.

**excel77** · 11-12-2008, 11:52 AM

Hello guys,

please can someone give me the assurance that my task can be done, i'm currently running out of time.

my currently level and what i have done is in the thread as an attachment. i will highly appreciate your help and concern here.

thanks, excel