Forum Discussion

pauljacobs's avatar
pauljacobs
Copper Contributor
Jan 31, 2024

Visual Basic No Longer Visible

I wanted to do two things with Visual Basic:  1) have the workbook open at a specific tab every time and 2) have a message pop up when the workbook opens.   I went to Options>Customize Ribbon and a...
Macros and VBA
HansVogelaar's avatar
HansVogelaar
MVP
Jan 31, 2024

pauljacobs 

In the Visual Basic Editor, select View > Project Explorer and View > Properties Window.

 

VBA expects "straight" quotes ", not "curly/smart" quotes “ and ”.

  • pauljacobs's avatar
    pauljacobs
    Copper Contributor
    Feb 01, 2024

    HansVogelaar 

     

    I already made the point about quotes.  I was going in to correct them, having already figured out what you just mentioned, when I was faced with the view shown in the screenshot on my initial post.

     

    I don't have a question about quotes.

     

    I do need help though.  Is it possible to bring your MVP abilities to bear on the question I actually asked?

     

    Thanks

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Feb 01, 2024

      pauljacobs 

      Once you have displayed the Project Explorer window, double-click ThisWorkbook under the relevant workbook.

      Copy code like this into the ThisWorkbook module:

      Private Sub Workbook_Open()
    Worksheets("Specic Sheet").Select
    MsgBox "Hello There", vbInformation
End Sub

      Switch back to Excel.

      Save the workbook as a macro-enabled workbook (*.xlsm)

Resources