W
William Jewell
Hello
I have made a mutiple sheet workbook in Exce 97. Many cells contain formulas involving inputs from data in other cells or sheets. All of this is driven from a "Territory Selection" Sheet in which a territory is selected which drives the results in other sheets. Everything works fine but I have two questions I can't figure out
1) I want to insure that only one Territory can be selected at a time. I have a warning message when any of the cells within the Selector Column are selected but want to automatically de-select any cell when another is selected
2) I currently accomplish selection by Typing "x" into the cell. Can this be accomplished by just pointing to the cell and right clicking? It would be great if clicking on the cell would clear any other selected cell and automatically enter the "x" for the user
Any help will really be appreciated
Thanks
William
I have made a mutiple sheet workbook in Exce 97. Many cells contain formulas involving inputs from data in other cells or sheets. All of this is driven from a "Territory Selection" Sheet in which a territory is selected which drives the results in other sheets. Everything works fine but I have two questions I can't figure out
1) I want to insure that only one Territory can be selected at a time. I have a warning message when any of the cells within the Selector Column are selected but want to automatically de-select any cell when another is selected
2) I currently accomplish selection by Typing "x" into the cell. Can this be accomplished by just pointing to the cell and right clicking? It would be great if clicking on the cell would clear any other selected cell and automatically enter the "x" for the user
Any help will really be appreciated
Thanks
William