Goto Previous worksheet
 

I've programmed a button to open/go to a hidden worksheet. On the hidden
worksheet, I've coded a button to hide it again. But how do I get the button
to take me back to the original worksheet (rather than going to the one next
to the hidden sheet)?

Goto Previous worksheet
 

Actually, let me clarify that the "open/go to hidden worksheet" button is on
a number of different worksheets, so simply coding the button to go back to a
specific worksheet will not do. It needs to remain generic and go back to
the worksheet that opened it in the first place. I hope this makes sense . .
..

"meb081505" wrote:

I've programmed a button to open/go to a hidden worksheet. On the hidden
worksheet, I've coded a button to hide it again. But how do I get the button
to take me back to the original worksheet (rather than going to the one next
to the hidden sheet)?

Goto Previous worksheet
 

One way is to create a Public variable as Integer

Than in you open/goto hidden worksheet you can set the variable = to the
active sheet index
x = activesheet.index

Than in your code to go back to the orginal (calling) worksheet, use
Sheets(x).Activate
or
Sheets(x).Select

Since x is declared as Public - it will retain it's value until it is
changed or the workbook is closed.

--
steveB

Remove "AYN" from email to respond
"meb081505" wrote in message
...
Actually, let me clarify that the "open/go to hidden worksheet" button is
on
a number of different worksheets, so simply coding the button to go back
to a
specific worksheet will not do. It needs to remain generic and go back to
the worksheet that opened it in the first place. I hope this makes sense
. .
.

"meb081505" wrote:

I've programmed a button to open/go to a hidden worksheet. On the hidden
worksheet, I've coded a button to hide it again. But how do I get the
button
to take me back to the original worksheet (rather than going to the one
next
to the hidden sheet)?