heres the dilema

do hyperlinks on excel sheets have codes???????

i have done a data base 4 college n 1 need to find codes n formulas

but i have used hyperlinks aswell as macros



soooooo
in visual basic u can see the code for macros

but not for hyperlinks

but a hyperlink must have a code somehere because there must be a code that tells the sheet that if you click this word/icon/picture it needs to go to this page or what ever

there MUST be a code!

but where

what i have done
created a hyperlink to take me from 'sheet1' to 'sheet2'
simple enough but where is the code


i need this for my testing!!!!

ty

somthing for the clever ppl

reply asap

I'm no VBA expert, but if you were to display the contents of a cell using VBA surely it would show you the actual contents rather than rendering it as a hyperlink as it does on the sheet.

Just use a macro to switch from sheet 1 to sheet 2
Display code in VB script

Use ctrl + `(key) to display formulars in excel.

Hope this helps.

Hyperlinks in word/excel are not part of VBA, they're OLE objects that invoke an action. Inserting a hyperlink is similar to inserting a WAV or AVI file into document. If you want to find out the hyper link url. Try this:


that will show the first URL in the cell A1, you can substitute the strings from the range array, and the item array with variables.

Hope this helps