Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for forward and back button
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for forward and back button
Hi Kim,
Next ActiveSheet.Next.Select Previous ActiveSheet.Previous.Select If this was helpful please click yes, thanks "Kim" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for forward and back button
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" wrote: Hi Kim, Next ActiveSheet.Next.Select Previous ActiveSheet.Previous.Select If this was helpful please click yes, thanks "Kim" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for forward and back button
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 "Kim" wrote: 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" wrote: Hi Kim, Next ActiveSheet.Next.Select Previous ActiveSheet.Previous.Select If this was helpful please click yes, thanks "Kim" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I call IE browser (Back button) through Excel macro? | Excel Discussion (Misc queries) | |||
How can I call IE browser (Back button) through Excel macro? | Excel Discussion (Misc queries) | |||
page forward button | Excel Discussion (Misc queries) | |||
Reverse a Macro - works like back button | Excel Discussion (Misc queries) | |||
Web-type Back and Forward navigation between Excel worksheets | Excel Worksheet Functions |