Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cursor and Sheet Protection may09
Hi All, I use the procs below to protect and unprotect sheets. At times, (and I can't find the 'pattern'), I lose the cursor after protecting the sheet. After 'manual' protection the cursor moves to a unlocked cell. If I've changed a locked cell in a macro, do I have to select a Not .Locked cell to make sure the cursor is there after protection ? Thanks. Sub UNprotectStdId(Ws As Worksheet, Optional Id As String = "") If Not Ws Is Nothing Then Ws.UNprotect Id End Sub ' Code to change a range Sub ProtectStdId(Ws As Worksheet, Optional Id As String = "", _ Optional SelectionType As Long = xlUnlockedCells) If Not Ws Is Nothing Then Ws.Protect Id, AllowFormattingCells:=True Ws.EnableSelection = SelectionType End If End Sub -- Neal Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
Putting Cursor in Cell A1 of each Worksheet, then ending cursor on smalest sheet name according to VBA Editor | Excel Programming | |||
Sheet protection error msg - Unrequested sheet activation | Excel Programming |