Macro for forward and back button

[Kim]

Hi,

Could someone please help me. This probably need macro.

I create 2 button in a sheet - one for forward and one for back. Their
function is to more to the next sheet or move to the previous sheet.

I tried to use hyperlink. The only problem is I have to set hyperlink on
every sheet. Is there a way or macro that I can assign to the button to tell
it to more to next or previous.

Thanks.
Kim

 

[Eduardo]

Hi Kim,

Next

ActiveSheet.Next.Select

Previous

ActiveSheet.Previous.Select

If this was helpful please click yes, thanks

 

[Kim]

Can you give the whole format for the macro. I'm new at it.

And I already have another macro - on Module 1

Sub MakeCopyOfMasterSheet()
Sheets("Master").Copy After:=Sheets(Sheets.Count)
End Sub

Regards,
Kim

 

[Eduardo]

Hi Kim,

First create the button

go to developer, insert, form controls, choose the first one, then go to the
spreadsheet where you want to draw the button and draw it, a dialog box will
open click New and where the cursor is tipr the sentence given, close Visual
basic and the button is ready to use, do the same with the previous button

Instructions given are for Excel 2007

Previous version

go to View, toolbars, forms and the button will be the 2nd in the right column

then follow the same procedure described above