Hi,

Is there any way to change the tab order when tabbing between locked cells
in a protected worksheet - through script or otherwise?

Regards
Pete

You can do it through code, though it won't be easy. Put this in the sheet
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call test
End Sub

and this in a module
Declare Function GetKeyState Lib "user32" _
(ByVal nVirtKey As Long) As Integer

Const VK_CONTROL As Integer = &H11 'Ctrl


Sub test()
If GetKeyState(vbKeyTab) < 0 Then Ctrl = True Else Ctrl = False
If Ctrl = True Then
Cells(1, 1).Select

End If
End Sub

this selects just one cell, you can integrate a counter or another method to
decide where to move to.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"PO" wrote:

> Hi,
>
> Is there any way to change the tab order when tabbing between locked cells
> in a protected worksheet - through script or otherwise?
>
> Regards
> Pete
>
>
>

Thanks John! This was exactly what I was looking for.

Regards
Pete


"John Bundy" <(E-Mail Removed)(remove)> skrev i meddelandet
news:50DB3603-D3E9-4633-893E-(E-Mail Removed)...
> You can do it through code, though it won't be easy. Put this in the sheet
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> Call test
> End Sub
>
> and this in a module
> Declare Function GetKeyState Lib "user32" _
> (ByVal nVirtKey As Long) As Integer
>
> Const VK_CONTROL As Integer = &H11 'Ctrl
>
>
> Sub test()
> If GetKeyState(vbKeyTab) < 0 Then Ctrl = True Else Ctrl = False
> If Ctrl = True Then
> Cells(1, 1).Select
>
> End If
> End Sub
>
> this selects just one cell, you can integrate a counter or another method
> to
> decide where to move to.
> --
> -John
> Please rate when your question is answered to help us and others know what
> is helpful.
>
>
> "PO" wrote:
>
>> Hi,
>>
>> Is there any way to change the tab order when tabbing between locked
>> cells
>> in a protected worksheet - through script or otherwise?
>>
>> Regards
>> Pete
>>
>>
>>