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,