Hello,

I have a few issues I’m hoping you can help me out with. First, can you tell me how to make a hyperlink to another excel workbook from within a cell. I have several instances where I need to insert a hyperlink within a cell which will then take the user to specific worksheets within a workbook which is independent of the calling workbook. The two workbooks reside in different locations therefore I must include the specific location (C:\Region\Regions.xls).

Second: Is there a VBA formula that I can use within a cell to link to another cell within a separate excel document (like OLE) but would then allow me to open/activate for input within that sourced document?

Thansk
Mike