Hello all!
I am setting up a data base for my coworkers and one column is a client phone number column.
I would like to create a vba that will link the cells in that column to a specific website that won't change even when my coworkers enter and/or change the phone numbers in the cells of that column.
I have been successful, just linking the column cells to the website (that part is an easy right click, as you know) but as soon as the phone number is deleted, changed or a new one is added, it overrides the link and clicking the cell then goes nowhere. How do I "lock" that website to the cells in that column so that regardless of the cell content, clicking on the cell always goes to the website?
Thanks
MJ
I am setting up a data base for my coworkers and one column is a client phone number column.
I would like to create a vba that will link the cells in that column to a specific website that won't change even when my coworkers enter and/or change the phone numbers in the cells of that column.
I have been successful, just linking the column cells to the website (that part is an easy right click, as you know) but as soon as the phone number is deleted, changed or a new one is added, it overrides the link and clicking the cell then goes nowhere. How do I "lock" that website to the cells in that column so that regardless of the cell content, clicking on the cell always goes to the website?
Thanks
MJ