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