ElvisSteel
Board Regular
- Joined
- Mar 23, 2009
- Messages
- 122
Ctrl+PgDn normally takes you to the next worksheet
If a worksheet is unprotected, or protected with all cells locked, this works fine.
If a worksheet has a mixture of locked and unlocked cells and is protected with "select unlocked cells" allowed, Ctrl+PgDn works differently and moves you across the workbook.
Is there a way of forcing Ctrl+PgDn to always take you to the next worksheet, regardless of the protection/cell locking used?
Thanks
If a worksheet is unprotected, or protected with all cells locked, this works fine.
If a worksheet has a mixture of locked and unlocked cells and is protected with "select unlocked cells" allowed, Ctrl+PgDn works differently and moves you across the workbook.
Is there a way of forcing Ctrl+PgDn to always take you to the next worksheet, regardless of the protection/cell locking used?
Thanks