Removing Multiple Hyperlinks
In VBA, you can 'see' the address of the hyperlink using:
Range(MyRange).Hyperlinks.Item(1).Address Olly "Dave Peterson" wrote in message ... In my experience, there usually isn't any code associated with the hyperlink. You can get to it by Selecting the cell with the link 1. rightclick and chose edit hyperlink 2. insert hyperlink or 3. ctrl-k RK wrote: Well I would think that I should see the VBA code for the hyperlink somewhere, so that I could change it if needed. I can highlight it with the mouse and it shows where it is pointing to, but how can I edit it? thank you for the reply RK |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com