I'm having problems with portions of images from one worksheet showing up or "ghosting" on another worksheet. I have a workbook with worksheet 1 being comprised solely of buttons to call up userforms and is the only sheet I want users to see or access. I have a macro created to sort a range in worksheet 3. Often, after the macro is executed, a portion of the highlighted range shows up on sheet 1. If I protect sheet 1, a larger image shows up and it happens every time. When I go into sheet 3, the range that was sorted is still highlighted. I've tried recording the Macro where at the end I click out of the range to clear it, but doesn't help.
My sort macro is as follows:
I'm a novice, so any help is appreciated.
My sort macro is as follows:
Code:
Range("B6:L220").Select
ActiveWindow.SmallScroll Down:=-213
ActiveWorkbook.Worksheets("Auction Items").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Auction Items").Sort.SortFields.Add Key:=Range( _
"B6"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Auction Items").Sort
.SetRange Range("B6:L220")
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Last edited by a moderator: