CODEWITHSUNDEEP
excelvba
Marktin John
Marktin John

Reputation: 1

VBA does not active

I suggest that my workbook contains a VBA code below. But It does not run when I opened my workbook too.

Sub Appl_StatusBar() 
      Application.StatusBar = "SupportABC" 
End Sub

Upvotes: 0

Views: 29

Answers (1)

BerticusMaximus
BerticusMaximus

Reputation: 725

If you put your code in the Workbook Open Event it will do what you need. To do this click the top dropdown where it says "(General)" and hit "Workbook". In the right dropdown select "Open" and save your code there". See below

Private Sub Workbook_Open()
    Application.StatusBar = "SupportABC"
End Sub

Upvotes: 1

Related Questions