Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 69
Default Ctrl+Page Down to navigate sheets

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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Ctrl+Page Down to navigate sheets

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

"TimT" wrote:

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone having Ctrl+C / Ctrl+V problems in E2007? Krzysztof Kruszynski Excel Discussion (Misc queries) 1 June 13th 07 01:41 PM
ctrl + tab (first in, first out history) with excel sheets? urlwolf Excel Worksheet Functions 4 March 30th 07 03:42 PM
why doesn't ctrl+page down work? Faith Excel Discussion (Misc queries) 2 May 21st 06 03:42 PM
Ctrl Page Down/Up carrera Excel Discussion (Misc queries) 1 September 12th 05 05:25 PM
Find (Ctrl +F) not searching all open sheets Caroline Excel Worksheet Functions 2 January 22nd 05 05:45 PM


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"