Cell Selection Problem

[hinklejt]

I have a code that finally does just about everything it needs to. My problem comes in because of clearing the formatting after a hyperlink is removed. if i make any changes to a cell it clears the formatting and then automatically selects back to that cell even if i click a different one. Anyone have any ideas around this? I dont need the formatting cleared everytime the cell is changed, only once after the hyperlink is removed. for example if i removed the hyperlink and edited the cell by highlighting it, itll work, but i ever need to make additional changes it will clear the formatting again. I attached my code, any help you can provide is appreciated! Thanks.

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[hinklejt]

THanks for the reply. What you have works very similar to what I have. The problem of cell selection is gone now, but the cell.locked=false is giving me issues. I get the following error message when I try make changes to the cell "Run-time error '1004': Unable to set the locked property of the range class. This only happens if the sheet is protected, which is a problem since it will be protected. not sure how to combat this. its got to be a protection problem that i haven't addressed in the code?

[AlphaFrog]

The code un-protects and re-protects the worksheet. Change the password to suit.

Please Login or Register  to view this content.

[hinklejt]

Thanks! I tried what you had and it took away all hyperlink functionality. What I found was that that I just needed to change the password formatting to Me.Unlock ("Password") instead.