Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return User to Last Active Worksheet
Howdy,
Here is my issue. I have workbook with 30 some odd sheets in it. Each sheet has a button that sends the user to a "Specs Sheet" that has all the averages on it. What I need to know, is what code is needed for a button to send the user to the last active worksheet that he or she was on. Any help is appreciated. Sorry I don't have a code, I really never have come across an issue of this type. -- Silverbird Designs @ www.silverbirddesigns.com Fighting Texas Aggie Class of 2009 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return User to Last Active Worksheet
Create a public variable and save the worksheet name when that button is
hit. Then just pick up that value when you need to return. Public SheetName As String Public Sub SpecsSheet() SheetName = Activesheet.Name Worksheets("Specs Sheet").Activate End Sub Public Sub Return() Worksheets(SheetName).Activate End Sub -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Texas Aggie" wrote in message ... Howdy, Here is my issue. I have workbook with 30 some odd sheets in it. Each sheet has a button that sends the user to a "Specs Sheet" that has all the averages on it. What I need to know, is what code is needed for a button to send the user to the last active worksheet that he or she was on. Any help is appreciated. Sorry I don't have a code, I really never have come across an issue of this type. -- Silverbird Designs @ www.silverbirddesigns.com Fighting Texas Aggie Class of 2009 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return to active cell | Excel Discussion (Misc queries) | |||
Displaying data in user form from active worksheet | Excel Programming | |||
Basic Question - How do I return the worksheet number of the active worksheet? | Excel Programming | |||
how can I return the active row and active column? | Excel Programming | |||
Return Row Heights for Rows in Active Worksheet - an example | Excel Programming |