S
sybmathics
Hi all,
Here is another freak question from one of my students:
"I receive a column with URL's where some are clickable and others
aren't. (blue or black)
When I get into a cell with an unclickable url and press F2 and next
Enter the URL becomes clickable again. Taking me to the clicked website.
When I have a column of 5 problematic URL's this is OK but when I have
thousands of rows I get tired.
Is there a way to in one command activate all unclickable URL's?"
My idea is that we ould need a macro to go to all rows and edit and confirm.
I could write the macro code myself, but my students are not into VBA yet.
So my question is:
Is there a shortcut key to enable all URL's in a column?
Greets,
Sybolt
Here is another freak question from one of my students:
"I receive a column with URL's where some are clickable and others
aren't. (blue or black)
When I get into a cell with an unclickable url and press F2 and next
Enter the URL becomes clickable again. Taking me to the clicked website.
When I have a column of 5 problematic URL's this is OK but when I have
thousands of rows I get tired.
Is there a way to in one command activate all unclickable URL's?"
My idea is that we ould need a macro to go to all rows and edit and confirm.
I could write the macro code myself, but my students are not into VBA yet.
So my question is:
Is there a shortcut key to enable all URL's in a column?
Greets,
Sybolt