![]() ![]() For example, if you have a function like this to hide the nav pane: Sub HideNavPane()Īccess tips: /tips. To display the old Notebook Pane at the left side of the application window, click the pin button in the Notebook Drop-Down. If an error is raised, I find that there's a very brief flash of the nav pane after the user acknowledges the error message, but it's not too bad.Īccess tips: Turn off screen updating, do the link, then hide the nav pane and turn screen updating back on. To select notebooks in OneNote 20, use the Notebook Drop-Down Navigation at the top of the program window, below the Ribbon. If no error is raised, the navigation pane never appears. MsgBox Err.description, vbExclamation, "Error " & Err.Number Then you can perform your link under control of a function like this: Private Sub LinkSpreadsheet()Īpplication.Echo False ' turn off screen updatingĭoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel12, "TEMPLEVPORTALUNDERLAG", strFolder3 & "NYTTLEVPORTALUNDERLAG" & ".xlsx", TrueĪpplication.Echo True ' turn on screen updating ![]() For example, if you have a function like this to hide the nav pane: Sub HideNavPane() Turn off screen updating, do the link, then hide the nav pane and turn screen updating back on.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |