View Single Post
  #2   Report Post  
ww
 
Posts: n/a
Default

When you first create the button an assign macro box should pop up. Click
the Record button on the right side. A Record Macro box will appear just
click okay. Then just click on the sheets tab you want to jump to. Click on
a cell within the sheet you want to go to. If nothing specific just click on
A1. Then go ToolsMacrostop recording. Now if you click on your button back
on the other sheet it should jump to the new sheet.

Hope that works for you.

"Darlenew" wrote:

Wud like to create a button to jump from sheet to sheet in a workbook, can
anyone help with this. I've gotten to inserting the button - and naming it,
then I'm lost
Want to click on the button and have it bring you to the reqired sheet. Can
anyone help with this.