Hello again...
You people have helped me do such a good job on the time sheets that my boss decided that i was the one to do the rest of the office's excel stuff... yay? so here i am again...
Got 3 questions:
1: Is there a way to insert the worksheet name into a cell, in a similar way that it is done in the header? Have looked at an answer by Juan to a seemingly similar question, but couldnt get it quite to work, or rather, didnt understand how it was mean to work... would prefer to not use code but...
2: Is there a way for a cell to find the most recent date in a column?
3: Is there code that will prevent user, regardless if push Enter or Tab, to jump to the next unlocked cell? Im using a mac, so the choice of choose only unlocked cells or whatever under protection is not available to me, as it seems to be on a PC...
Answers to any of the above are welcome =)
You people have helped me do such a good job on the time sheets that my boss decided that i was the one to do the rest of the office's excel stuff... yay? so here i am again...
Got 3 questions:
1: Is there a way to insert the worksheet name into a cell, in a similar way that it is done in the header? Have looked at an answer by Juan to a seemingly similar question, but couldnt get it quite to work, or rather, didnt understand how it was mean to work... would prefer to not use code but...
2: Is there a way for a cell to find the most recent date in a column?
3: Is there code that will prevent user, regardless if push Enter or Tab, to jump to the next unlocked cell? Im using a mac, so the choice of choose only unlocked cells or whatever under protection is not available to me, as it seems to be on a PC...
Answers to any of the above are welcome =)