![]() |
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