Ctrl+Page Down to navigate sheets

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top