![]() |
Can I tell what cell I was in last?
I now have my hyperlinks working (many thanks to Vergel Adriano), but I'd
really like to know if I landed on the current cell as a result of clicking a hyperlink or just clicking on the cell. When my user goes to a cell a form opens up, for data entry, if the user accepts the values and they arrived there by using a hypelink, I want to delete the hypelink. I am reluctant just to delete the hyperlink once clicked in case there is a query with the values linked to. But if I could tell where I had come from, I could add code to my OK button, to delete the hyperlink. Hope that makes sense! |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com