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
-
- 3StarLounger
- Posts: 357
- Joined: 02 Jun 2013, 05:55
- Location: Australia - SOUTH MORANG - A northern suburb of the city of MELBOURNE in the state of Victoria
Your Age on Another Planet
You do not have the required permissions to view the files attached to this post.
George
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Your Age on Another Planet
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...
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...
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78790
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Your Age on Another Planet
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
Activate the Error Alert tab.
Enter a warning to be displayed if the user enters YES more than once.
Click OK.
Select B13:I13, then select Data > Validation...
From the allow dropdown, select Custom.
Enter the formula
=COUNTIF($B$13:$I$13,"yes")<=1
Activate the Error Alert tab.
Enter a warning to be displayed if the user enters YES more than once.
Click OK.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Your Age on Another Planet
- I completely overlooked that option....Good suggestion (and MUCH simpler!!!)
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 357
- Joined: 02 Jun 2013, 05:55
- Location: Australia - SOUTH MORANG - A northern suburb of the city of MELBOURNE in the state of Victoria
Re: Your Age on Another Planet
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.
HansV, I have refined the file as per your suggestion and I am happy with the results.
George
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.