-
Hmm, maybe I better explain better what I'm trying to do.
If I have a long list with the first 6 rows frozen, I'll usually use the one-line code above so that if I click anywhere in those 6 header rows, the cursor jumps to the top of the list, B7 for example.
But if I have any comments showing, which I now do in a current project, clicking in the comment box puts me in the comment instead of jumping me to B7.
Is there some kind of change that would be triggered by clicking in the comment that I could then use to trigger Range("B7").Select?
Don't worry about text boxes, I don't need them in the Header rows, but I'd like to deal with the comments.
Andy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules