Skip to main content
Super User

Return to Answer

formatting
Source Link
edit approved Feb 5, 2021 at 8:05
ZygD
edit approved Feb 5, 2021 at 8:05
ZygD
  • 2.5k
  • 12
  • 27
  • 43
  1. Open development tab -> open Visual Basic
  2. menuMenu: insert -> module
  3. pastePaste the following code under vbaproject(personal.xlsb)

Public Sub Opener()
Application.Dialogs(xlDialogOpen).Show ActiveWorkbook.Path+"\"
End Sub


Public Sub Opener()
    Application.Dialogs(xlDialogOpen).Show ActiveWorkbook.Path+"\\"
End Sub
  1. saveSave and close the VBA
  2. modfyModify quick access toolbar and add the macro Opener (remember to add icon as well)
  1. Open development tab -> open Visual Basic
  2. menu insert -> module
  3. paste the following code under vbaproject(personal.xlsb)

Public Sub Opener()
Application.Dialogs(xlDialogOpen).Show ActiveWorkbook.Path+"\"
End Sub

  1. save and close the VBA
  2. modfy quick access toolbar and add the macro Opener (remember to add icon as well)
  1. Open development tab -> open Visual Basic
  2. Menu: insert -> module
  3. Paste the following code under vbaproject(personal.xlsb)

Public Sub Opener()
    Application.Dialogs(xlDialogOpen).Show ActiveWorkbook.Path+"\\"
End Sub
  1. Save and close the VBA
  2. Modify quick access toolbar and add the macro Opener (remember to add icon as well)
Source Link
Andrew Tran
Andrew Tran
  • 11
  • 1

  1. Open development tab -> open Visual Basic
  2. menu insert -> module
  3. paste the following code under vbaproject(personal.xlsb)

Public Sub Opener()
Application.Dialogs(xlDialogOpen).Show ActiveWorkbook.Path+"\"
End Sub

  1. save and close the VBA
  2. modfy quick access toolbar and add the macro Opener (remember to add icon as well)