Your Age on Another Planet

[geecee]

Here's a little something compiled in Microsoft Excel 97. You would be the same age - in Earth years - wherever you were, but have you thought what age you would be in the years of any one of the other 8 planets? At present, all planets can be selected which I don't suppose makes any difference one way or the other, but I would like to see - for my personal interest - if it could be refined so that when one planet has been selected the others can't. I don't know how.

Your Age on Another Planet.xls

[Rudi]

Hey... is Pluto a planet again
I LOVE my age on Mars... I'd be so young again lol...

Your query would involve protecting cells to prevent them being selected, and then have an event based macro (using the selection change event) to toggle the lock/unlock status of the cells based on what cell is selected. I wish you had posted this last week, while I was on leave...It would have given me something to do to wade away the time I had to play around with this and create some sample code...

[HansV]

You could use Data Validation. You have to unprotect the sheet before applying it.

Select B13:I13, then select Data > Validation...
From the allow dropdown, select Custom.
Enter the formula

=COUNTIF($B$13:$I$13,"yes")<=1

S145.png

Activate the Error Alert tab.
Enter a warning to be displayed if the user enters YES more than once.

S146.png

Click OK.

[Rudi]

- I completely overlooked that option....Good suggestion (and MUCH simpler!!!)

[geecee]

Hi Rudi and HansV. Thanks to both of you for your input.

HansV, I have refined the file as per your suggestion and I am happy with the results.