If you aren't going to use the built in shortcut keys, it is
Easier to use the built in methods for this

Sub Moveright()
On Error Resume Next
activesheet.Next.Activate
End Sub

sub MoveLeft()
on Error Resume Next
activesheet.Previous.Activate
End Sub

--
Regards,
Tom Ogilvy

"Jonsson " wrote in message
...
Hi all,

I need help to create 2 macro. One that choose the sheet before the
active sheet, and one that choose the sheet after the active sheet,
nomatter whats the name of the sheet.
Just navigate to the sheet left of the active sheet, and right of the
active sheet.


Any help is appreciated!!

//Thomas


---
Message posted from http://www.ExcelForum.com/