April 27, 2024

MoDCore

Welcome to the core

Use Buttons to Navigate Sheets

This a quick simple way to show how to use buttons to navigate the on the to different worksheets.

From Developer tab, create a new button and assign the following macro to it.

Heres the code – Part in Bold you will need to change to the sheet you want.
Sub Button1_Click()
ThisWorkbook.Sheets(“Worksheetname“).Activate
End Sub
Nice and simple!
Copyright © All rights reserved. | Newsphere by AF themes.