Tag Archives: vba

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 […]

Read More