Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file automatically adding hyperlinks
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. What else could be causing this behavior? Here is the macro I created in case it is relevant: Sub RemoveHyperLinks() Range("A2:A999").Hyperlinks.Delete End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
file automatically adding hyperlinks
I would look at the users AutoCorrect listing under Tools=Autocorrect and
see if there is a defintion that turns an entry into a hyperlink. If you don't find anything there, see what addins are loaded. -- Regards, Tom Ogilvy "Robin Witkop-Staub" wrote in message ... 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. What else could be causing this behavior? Here is the macro I created in case it is relevant: Sub RemoveHyperLinks() Range("A2:A999").Hyperlinks.Delete End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding row to sheet; having hyperlinks follow | Excel Worksheet Functions | |||
Stop automatically creating hyperlinks | Links and Linking in Excel | |||
hyperlinks changed automatically in excel. | Excel Discussion (Misc queries) | |||
How to automatically create hyperlinks with excel | Excel Worksheet Functions | |||
Setting up hyperlinks automatically | Excel Worksheet Functions |