ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   protected sheet cursor movement (https://www.excelbanter.com/excel-worksheet-functions/182977-protected-sheet-cursor-movement.html)

Pa Maher

protected sheet cursor movement
 
When my worksheet is protected, when TAB is hit, the cursor move across then
down. Is there anyway to make it move down then across?

Gord Dibben

protected sheet cursor movement
 
No.

There are other methods.

See Bob Phillips' site for using a Named Range

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You could also use VBA event code to move any order you wish.

Post back if interested.


Gord Dibben MS Excel MVP

On Tue, 8 Apr 2008 11:09:01 -0700, Pa Maher
wrote:

When my worksheet is protected, when TAB is hit, the cursor move across then
down. Is there anyway to make it move down then across?




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

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