1) Where does the button come from? Forms toolbar, or control toolbox toolbar?
2) Where is the button placed (what sheet)
3) What is the name of the sheet you want to move to?
The button comes from form toolbar. (However I am open to using the control toolbar if that is a better option.)
The button is located currently (on top of cells d30,e30,f30,d31,e31,f31) [although it can be placed where ever)
The current sheet that it is on is called "Shipments by Service Level" When clicked I would like for it to load "Shipments by Service Level 3"
Build yourself a general module macro
Right click on the button, select assign macro, and assign the above macro.VB:Sub changesheets() sheets("Shipments by Service Level 3").select End Sub
When pressed, it should take you to the nominated sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)