View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Graham Y Graham Y is offline
external usenet poster
 
Posts: 66
Default 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!