stevebigtk
New Member
- Joined
- Nov 11, 2013
- Messages
- 15
Hi there
I'm trying to set specific tabbing rules in a worksheet. The below code (kindly provided by mikerickson) works fine when the sheet is unlocked, but when it's locked, it will tab back to a merged and necessarily unlocked cell. I can't work out how to get round this! I need the merged cells to remain merged and the sheet to remain locked. Below is the code and a link to the sheet...
http://www.filedropper.com/tabbingissue
Any help very much appreciated!
Thanks
I'm trying to set specific tabbing rules in a worksheet. The below code (kindly provided by mikerickson) works fine when the sheet is unlocked, but when it's locked, it will tab back to a merged and necessarily unlocked cell. I can't work out how to get round this! I need the merged cells to remain merged and the sheet to remain locked. Below is the code and a link to the sheet...
http://www.filedropper.com/tabbingissue
Code:
<code style="border: 0px; font-family: 'Segoe UI', Arial, sans-serif; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased;">Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static NextCell As Range If NextCell Is Nothing Then If Target.Cells.Count = 1 And Not (Application.Intersect(Target, Range("L6,L12,L18,L24,L30")) Is Nothing) Then Set NextCell = Target.Offset(2, -8) End If Else Application.EnableEvents = False NextCell.Select Set NextCell = Nothing End If Application.EnableEvents = TrueEnd Sub</code></pre>
Any help very much appreciated!
Thanks