excel multilple sheets

[Arr]

Need to branch to another sheet in the workbook and then return to the
sheet that the branch was started from!

Now for the kicker

The user can change the name of the sheet that the program runs from!!

 

[Dave Peterson]

Chip Pearson just posted some code (you wanted code???) that works very nicely.

http://groups.google.com/[email protected]

It works if the sheet has been renamed, too.

 

[Earl Kiosterud]

Arr,

Put this in a module:

Dim SheetReturn As String

Sub GotoSheet()
SheetReturn = ActiveSheet.Name ' save current sheet name
Sheets("Sheet2").Select
End Sub

Sub GoBackSheet()
If SheetReturn <> "" Then Sheets(SheetReturn).Select
SheetReturn = ""
End Sub

Run the macros from the respective sheets.