How to direct hyperlinks in PowerPoint to specific Excel tabs?

Question

excel

How to direct hyperlinks in PowerPoint to specific Excel tabs?

Answer 1

You can create a macro-enabled presentation. Insert the following code into the module:

Public Sub OpenExcelBook()
Dim xlApp As Object, xlBook As Object

Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlBook = xlApp.Workbooks.Open("C:\1\Book1.xls") ' Открытие книги Excel

xlBook.Sheets(2).Activate                      ' Активация второго листа книги
xlBook.Sheets(2).Range("A10").Select    ' Переход к ячейке A10

Set xlBook = Nothing: Set xlApp = Nothing
End Sub

Select the desired inscription on the presentation, then: Insert - Action - On mouse click - Action. And choose a macro to execute "OpenExcelBook".