Open excel Visual basic code window by clicking on hyperlink
 

Hi all, i downloaded an excel file in which there is a hyperlink.
When i click on this link it opens up the excel visual basic code
window. I found it intersting as I normally open it by right clicking
on sheet tab and selecting "View Code". Does any body know how can you
open excel Visual basic code window form following a hyperlink in a
cell.

Open excel Visual basic code window by clicking on hyperlink
 

Application.VBE.MainWindow.Visible = True



"K" wrote in message
...
Hi all, i downloaded an excel file in which there is a hyperlink.
When i click on this link it opens up the excel visual basic code
window. I found it intersting as I normally open it by right clicking
on sheet tab and selecting "View Code". Does any body know how can you
open excel Visual basic code window form following a hyperlink in a
cell.