input text on sheet - macro

[bluepenink]

Hello

in my sheet1, i would like cell F5 to say "no sort"

i have a sort button that when clicked, tells the user in cell F5 i.e. Sorted by: Name

so when the user has not selected anything i.e. opened the workbook etc, i would for it to say "no sort"

any ideas? thxs

 

[craig.penny]

Are you asking for a method to put "no sort" in F5 of "sheet1" every time the workbook is opened?

If that's accurate, this is what you need:

Private Sub Workbook_Open()
 
      ThisWorkbook.Sheets("Sheet1").Range("F5") = "No Sort"
      
End Sub

That code needs to be in the ThisWorkbook code module.