Edit macro to make it run on open
Posted by Dwight on June 13, 2001 7:06 AM
How do I edit the following macro to make it run whenever the workbook it is contained in is opened?
Thanks.
ActiveSheet.Unprotect
Range("A9").Select
ActiveWindow.SmallScroll Down:=190
Range("A9:D209").Select
Selection.Sort Key1:=Range("B9"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Range("B9").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios _
:=True
End Sub