Previous Sheet
 

Hi,

I am using the next function ActiveSheet.Previous.Activate with a
button to move to the previous sheet.
The button is on every sheet and should always go back till the first
one.
All works fine until i get to a sheet that doesnt go back to the one
before.
If i move manually and then press the button i can skip that sheet.

Whats wrong?
any other way of doing that?

Thanks,

Previous Sheet
 

If Activesheet.Index 1 then Activesheet.Previous.Activate

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vandaley" wrote in message
oups.com...
Hi,

I am using the next function ActiveSheet.Previous.Activate with a
button to move to the previous sheet.
The button is on every sheet and should always go back till the first
one.
All works fine until i get to a sheet that doesnt go back to the one
before.
If i move manually and then press the button i can skip that sheet.

Whats wrong?
any other way of doing that?

Thanks,

Previous Sheet
 

Sorry mate but it still doesnt work.
i am stuck on the same sheet and it doesnt go back.

Any idea?

Bob Phillips wrote:
If Activesheet.Index 1 then Activesheet.Previous.Activate

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vandaley" wrote in message
oups.com...
Hi,

I am using the next function ActiveSheet.Previous.Activate with a
button to move to the previous sheet.
The button is on every sheet and should always go back till the first
one.
All works fine until i get to a sheet that doesnt go back to the one
before.
If i move manually and then press the button i can skip that sheet.

Whats wrong?
any other way of doing that?

Thanks,

Previous Sheet
 

Post all your code.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vandaley" wrote in message
ups.com...
Sorry mate but it still doesnt work.
i am stuck on the same sheet and it doesnt go back.

Any idea?

Bob Phillips wrote:
If Activesheet.Index 1 then Activesheet.Previous.Activate

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vandaley" wrote in message
oups.com...
Hi,

I am using the next function ActiveSheet.Previous.Activate with a
button to move to the previous sheet.
The button is on every sheet and should always go back till the first
one.
All works fine until i get to a sheet that doesnt go back to the one
before.
If i move manually and then press the button i can skip that sheet.

Whats wrong?
any other way of doing that?

Thanks,

Previous Sheet
 

Bob's code works for me. Are there any hidden
worksheets? If the previous sheet is hidden then
Activate (silently) fails.

Andrew

vandaley wrote:
Sorry mate but it still doesnt work.
i am stuck on the same sheet and it doesnt go back.

Any idea?

Bob Phillips wrote:
If Activesheet.Index 1 then Activesheet.Previous.Activate

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vandaley" wrote in message
oups.com...
Hi,

I am using the next function ActiveSheet.Previous.Activate with a
button to move to the previous sheet.
The button is on every sheet and should always go back till the first
one.
All works fine until i get to a sheet that doesnt go back to the one
before.
If i move manually and then press the button i can skip that sheet.

Whats wrong?
any other way of doing that?

Thanks,