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,