Ctrl+Page Down to navigate sheets

T

TimT

Hey everybody,
I'm stumped here...
Is there a way to set the navigation order of the worksheets when you use
Ctrl+Page Down or Up?
I have 36 Sheets that I have arranged in a certain order (not numerical), if
I'm on the first sheet (left most sheet) which happens to be Sheet28 and if I
use Ctrl+Page Down to navigate to the next one over to the right it goes to
the last one furthest to the right.
And it's only with Sheet28 the rest seem to work fine.

Help?
 
D

DazzaData

sounds like an OnActivate macro maybe telling it to go the the last sheet
when you activate the one to the right of sheet28

try opening the workbook with macros disabled and see if it does it then
 
Top