Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA for Skipping Cells
Can someone tell me the code for skipping all locked cells; using the tab key
to skip to unlocked cells . . . thanks for your time . . . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TAB BUTTON - VBA TO SKIP CELLS
Could i not set this up with this formula but use the "Tab" Key instead of
Cntrl-E "Gary''s Student" wrote: If you assign a shortcut key like CNTRL-e to: Sub nonlocked() ' ' gsnuxx ' startit = False For Each r In ActiveSheet.UsedRange If startit Then If r.Locked Then Else r.Select Exit Sub End If End If If Intersect(r, ActiveCell) Is Nothing Then Else startit = True End If Next End Sub You can "tab" over locked cells by touching CNTRL-e rather than the TAB key. -- Gary''s Student - gsnu200770 "MarthaSue" wrote: Can someone tell me the code for skipping all locked cells; using the tab key to skip to unlocked cells . . . thanks for your time . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
Sum and skipping cells | Excel Worksheet Functions | |||
Skipping Cells | Excel Worksheet Functions | |||
skipping cells | Excel Programming | |||
skipping cells | Excel Discussion (Misc queries) |