VBA Excel help

I have an excel file which needs to run a Before save macro based on the value in the dropdown. I am new and picked a macro from internet and customized it to save the file and export a range to text file. Now the plan is to have different worksheets in this workbook. The user will change the drop down and select the sheet name which should run the particular before saving of the sheet and export the data in a text file . This is the working code for before saving which needs to be called based on drop down value Sub Worksheet_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim ExpRng As Range Dim myTab As String Open [login to view URL] & "\[login to view URL]" For Output As #1 Set ExpRng = Worksheets("UPLOAD").Range("A1:T299").CurrentRegion FirstCol = [login to view URL](1).Column LastCol = FirstCol + [login to view URL] - 1 FirstRow = [login to view URL](1).Row LastRow = FirstRow + [login to view URL] - 1 For r = FirstRow To LastRow Data = "" For c = FirstCol To LastCol If c = 1 Then myTab = "" Else myTab = vbTab ' data = [login to view URL](r, c).Value Data = Data & myTab & [login to view URL](r, c).Value Next c Print #1, Data Next r Close #1 I am using this code to call the before save but looks like code needs some edit Private Sub Worksheet_Change(ByVal Target As Range) If [login to view URL] = "$F$11" Then On Error GoTo bm_Safe_Exit [login to view URL] = False Select Case [login to view URL] Case "Rogers" Call Worksheet_BeforeSave Case "BMO" Call BMO Case Else 'Do Nothing End Select End If bm_Safe_Exit: [login to view URL] = True End Sub