![]() In the opening Macro dialog box, click to highlight the macro of Select Last, and then click the Options button.Ħ. Note: By default the Developer tab does not display in Ribbon, click to know how to show/display developer tab in Excel Ribbon.ĥ. ![]() Click Developer > Macros to open the Macro dialog box. If you prefer to shortcuts to switch between current sheet and last used one, please go ahead:Ĥ. You can press F5 key or click the Run button to go back to the last used worksheet at once. ![]() VBA 2: Go back to previous/last sheet Public LastSheet As String Keep selecting ThisWorkbook in the left bar, and then click Insert > Module, and paste following code into the opening Module window: VBA 1: Go back to previous/last sheet Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)ģ. ![]() Double click the ThisWorkbook in the left bar, and then paste the following code into the opening window: Press Alt + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. The following VBA code enables you to switch between last used sheet and current sheet in current workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |