Copyright 2005, QAIX.comQAIX / QAIX.com2008-04-15 00:17:27tag:nath4564.qaix.com,2008-04-15:/0-303-locking-a-cell-dependant-upon-the-value-in-the-cell-excel.zhtmlnath4564http://qaix.com/users/nath4564/<br>Hi<br>I have a sheet full of look ups, charts etc. that I have designed for managing projects and resources, I want this tool to be used by my team but need various cells to be locked dependant upon the value that appears as per the lookups. the lookups are date dependant so as the date changes the cells values will also change.<br><br>can anyone please help me with this?<br><br>[<a href="http://nath4564.qaix.com/0-303-locking-a-cell-dependant-upon-the-value-in-the-cell-excel.zhtml#add">Add comment to QAIX.com</a>] [<a href="http://qaix.com/p/register.cgi">Start blog at QAIX.com</a>]nath45642008-04-15T00:26:30-00:002008-04-15T00:26:30-00:00tag:nath4564.qaix.com,2008-04-15:/0-302-hyperlink-a-lookup-value-in-excel.zhtmlnath4564http://qaix.com/users/nath4564/<br>Hi<br>I am putting a tool together with a validation (drop list) box with a selection of variables. Once an option is selected, lets say a football team, I have various other statistics that appear all over the page. What I need is a button on that page where the link will change as the team selected changes so if the button is clicked it will follow the hyperlink that is specific to the selected choice from the drop box.....<br><br>Can anyone help with this?<br><br>[<a href="http://nath4564.qaix.com/0-302-hyperlink-a-lookup-value-in-excel.zhtml#add">Add comment to QAIX.com</a>] [<a href="http://qaix.com/p/register.cgi">Start blog at QAIX.com</a>]nath45642008-04-15T00:23:01-00:002008-04-15T00:23:01-00:00