R
Robin Witkop-Staub
I have a user that uses Excel 2000 quite a bit. She suddenly started having
problems with hyperlinks being added to all the cells in her file.
Everytime she clicked on a cell it tried to open a specific webpage. I
thought it was a one-time mistake so I downloaded and created a macro called
"removeHyperlinks" from mrexcel.com to automatically remove all the
hyperlinks in the cells. This worked and I thought it was solved. The next
day she called me back and said the hyperlinks were back, and it was
happening in more than one file now. She states she will be working along
and suddenly they hyperlinks appear. She has to create the
"RemoveHyperlinks" macro in the file and run it to keep working. After a
while it happens again. I looked and I do not see any other macro's in the
list except for the "RemoveHyperlinks" one I made.
I checked the Autocorrect and nothing seemed unusual or setup to replace
with weblink. I shut off Autocorrect for testing. The only Addon she has
enabled is the Analysis Toolpak. She was using the Autosave addon but she
shut that off last week for testng too. I have talked to the user and she
says she can not detect any pattern causing the issue. I ran excel in safe
mode and it still happened.
I uninstalled, deleted the remaining orphan files/directories, and
reinstalled. Everything was working fine for a few hours and then suddenly
the problem came back. Again it is only happening on this particular PC so
it is not a setting in the actual file. The user did say that she swaps
these files with vendors via email, they make additions, and then send them
back. She saves the files over the original after receiving them. Sounds
to me like a vendor might be doing something to cause the problem, but
wouldn't this still require a VBSript or Macro of some sort to run? Where
could it possibly be hiding? What else could be causing this behavior?
PS: Here is the macro I created in case it is relevant:
Sub RemoveHyperLinks()
Range("A2:A999").Hyperlinks.Delete
End Sub
problems with hyperlinks being added to all the cells in her file.
Everytime she clicked on a cell it tried to open a specific webpage. I
thought it was a one-time mistake so I downloaded and created a macro called
"removeHyperlinks" from mrexcel.com to automatically remove all the
hyperlinks in the cells. This worked and I thought it was solved. The next
day she called me back and said the hyperlinks were back, and it was
happening in more than one file now. She states she will be working along
and suddenly they hyperlinks appear. She has to create the
"RemoveHyperlinks" macro in the file and run it to keep working. After a
while it happens again. I looked and I do not see any other macro's in the
list except for the "RemoveHyperlinks" one I made.
I checked the Autocorrect and nothing seemed unusual or setup to replace
with weblink. I shut off Autocorrect for testing. The only Addon she has
enabled is the Analysis Toolpak. She was using the Autosave addon but she
shut that off last week for testng too. I have talked to the user and she
says she can not detect any pattern causing the issue. I ran excel in safe
mode and it still happened.
I uninstalled, deleted the remaining orphan files/directories, and
reinstalled. Everything was working fine for a few hours and then suddenly
the problem came back. Again it is only happening on this particular PC so
it is not a setting in the actual file. The user did say that she swaps
these files with vendors via email, they make additions, and then send them
back. She saves the files over the original after receiving them. Sounds
to me like a vendor might be doing something to cause the problem, but
wouldn't this still require a VBSript or Macro of some sort to run? Where
could it possibly be hiding? What else could be causing this behavior?
PS: Here is the macro I created in case it is relevant:
Sub RemoveHyperLinks()
Range("A2:A999").Hyperlinks.Delete
End Sub