So I followed the directions to “Insert/ OLE Object” feature but it doesn’t seem like there is a way to link to a tabbed sheet in the same project because it opens up to Windows files. Is there a way to do this?
Weird, it looks like if I drop a Nagivator *Sheets" link from the from one internal sheet to the other internal sheet it does what I want it to do but you can’t make an OLE object to do the same thing?
Oh, got it figured out via searching. Solution.
" For navigating between sheets via a hyperlink dialog:
- Select the cell or object to hold the link.
- Open the Hyperlink dialog (Ctrl+K).
- In the Document section, specify the target in the “Target in the document” field using the format
SheetName!CellAddress(e.g.,Sheet2!G10). - Click Apply to create a clickable link that jumps to the specified sheet when activated."