Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have the following code that works except for the ActiveSheet.Unprotect and ActiveSheet.Protect (no password to be used), I suspect that I do not have it in the proper arrangement / location. Can someone help? Option Explicit Sub RANKING_SORT() ActiveSheet.Unprotect Dim source As Range With ActiveSheet Set source = .Range(.Range("A11"), .Range("AR11").End(xlDown)) End With source.Sort source.Range("V11"), xlAscending ActiveSheet.Protect End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
Protect/UnProtect Project (code) via VBA? | Excel Programming | |||
Generic protect/unprotect code through buttons and code? | Excel Programming | |||
Please help!!! Using code to password-protect and unprotect... | Excel Programming | |||
VBA code - protect and unprotect a sheet | Excel Programming |