Ctrl+Page Down to navigate sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top