6/16/2018 - 11:04 AM

Make a subroutine private

Makes a subroutine private, so a user cannot run this subroutine on its own

Private Sub ClearFormatting() ' Adding private keyword makes a subroutine inaccessible directly

' Clears the formatting on all the cells in the sheet

    'Select all the cells in the sheet and clears formatting
    Cells.Interior.Pattern = xlNone
End Sub