After reviewing some comments about macros, I thought I would share the only macros I actually utilize in my Excel program. The macros used in this program are only to open and close a worksheet or print a hidden worksheet when pressing a button so that it keeps the interface clean...that's it. As far as putting a button on the spreadsheet, no programming skills are required.
Below is all it took for the macro to work, and I just keep reusing the two codes for each button I add and rename as required.
-----------------------------------------------------------------------------------------------------
(MACRO #1 OPENS AND CLOSES WORKSHEETS)
Sub Open_MainMenu()
ActiveWindow.SelectedSheets.Visible = False
Sheets("Main Menu").Visible = True
Sheets("Main Menu").Select
Range("B20").Select
End Sub
-----------------------------------------------------------------------------------------------------
(MACRO #2 PRINTS A HIDDEN WORKSHEET THEN HIDES IT AGAIN)
Sub Print_Lease_Agreement()
Sheets("Lease Agreement").Visible = True
Sheets("Lease Agreement").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1
ActiveWindow.SelectedSheets.Visible = False
End Sub
-----------------------------------------------------------------------------------------------------
Once the macros are created, I insert a button and assign the macro to it. When I click on the button, the assigned macro runs.
Once you make one of these macros, just copy and paste to recreate it for another button to control a worksheet. In fact, copy my code and try it out! I am considering the creation of a 3 minute video to show how this is done in case anyone is interested. I am a visual person and this is a whole lot of typing for me!!