ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to move to the next worksheet if its protect (https://www.excelbanter.com/excel-discussion-misc-queries/69358-how-move-next-worksheet-if-its-protect.html)

stbrown22

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com