Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error with sorting
I have a file that I want the user to click an insert button and not
be able to insert rows. I have protected the sheet, except for the area they can enter data into and have created another Sort button. My code keeps errors at the sort stage. Any help is appreciated. Private Sub NFP_Sort_Click() Const PWORD As String = "123456" Application.ScreenUpdating = False With Worksheets("Southeast - NFP") .Select .Unprotect Password:=PWORD .Range("NFP_Sort").Select .Sort Key1:=Range("Q7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal .Range("Total_NFP").Select .Protect Password:=PWORD End With Application.ScreenUpdating = False End Sub Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Sorting Error | Excel Worksheet Functions | |||
sorting error | Excel Programming | |||
sorting error | Excel Worksheet Functions | |||
error in sorting | Excel Programming |