Monday, July 4, 2022

VB.NET in Excel VBA to activate the sheet in "Microsoft Excel Objects"

 > Open Excel

> Click on Developer and than click on Visual basic or Press Alt+F11

> Under "Microsoft Excel Objects"> Click on sheet1 > Write below code

Sub ActivateSheet()

Worksheets("Sheet2").Activate

End Sub

> Click on run or Press F5

No comments:

Post a Comment