Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
stbrown22
 
Posts: n/a
Default How to move to the next worksheet if its protect

Hi,

I have an excel document containing 20 worksheets. I use the shortcut keys
of Control+pgup/down to cycle between the different works sheets.

I have encountered an issue that if I protect a worksheet (the middle one
for instance) I can no longer use the next/previous short cuts key to move
beween worksheets. Once it hits the protected work sheet, control+pgup will
only move within the worksheet and not to the next worksheet.

I have tried it on differnt machines running Excel 2000 and all have the
same issue

I hope that makes sense and hope that someone can assist

Thanks,

Steve
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
Keyboard Shortcut to move to top of column in worksheet? piddilin Excel Discussion (Misc queries) 6 April 25th 23 03:43 AM
Reference External Worksheets & Protect Worksheet / Workbook DGM Excel Worksheet Functions 0 January 9th 06 10:31 PM
How Do I Protect A Worksheet But Allow Copying Columns KMH Excel Discussion (Misc queries) 1 January 3rd 06 03:51 PM
How to protect a worksheet from being copied to another worksheet SurvivorIT Excel Discussion (Misc queries) 3 August 31st 05 01:53 PM
How do I protect a worksheet from being copied & pasted? JJ Excel Discussion (Misc queries) 3 July 28th 05 02:07 PM


All times are GMT +1. The time now is 05:44 PM.

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"