if I have in the tab order Sheet1 Sheet2 Sheet3

and I have Sheet2 as the active sheet,

Activesheet.Previous.Select selects sheet1.

If you want to select Sheet3, then it would be Activesheet.Next.Select

You must have a different definition of Previous than Excel.

With either, you get an error if you try to select a sheet that doesn't
exist.

--
Regards,
Tom Ogilvy


"Mara Campos" wrote in message
...


That code (Activesheet.previous.Select) will take me one worksheet ahead
not to the previous worksheet I was on "last worksheet". Can you help
me with that?
Ex: I have links on worksheet1 that will direct me to diagrams in
worksheet 6 but want the command button on worksheet6 to take me back to
the location I started at which would be worksheet1, in this case.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!