Hi, still very new at macros and could use some assistance,
On the sheet "WorkBookSetUp" I am putting drop boxes in Column F starting with Row 3 and extending to row 13. Each will have option of Yes or No. I would like the other sheets in the work book to appear if yes is selected and disappear if no is selected. My first sheet to disappear/reappear is called "AcidCalculator".
Digging through the forums here and elsewhere I got the following macro, copied it into the code box for "workbooksetup" filled in the sheet name and the reference, hit run but I get a compile error "end if without block if" which i do not understand. Can someone please assist me in correcting my errors so I can complete this project.
Private Sub Worksheet_Change(ByVal Target As Range)
If "f3" = "yes" Then
End Sub
On the sheet "WorkBookSetUp" I am putting drop boxes in Column F starting with Row 3 and extending to row 13. Each will have option of Yes or No. I would like the other sheets in the work book to appear if yes is selected and disappear if no is selected. My first sheet to disappear/reappear is called "AcidCalculator".
Digging through the forums here and elsewhere I got the following macro, copied it into the code box for "workbooksetup" filled in the sheet name and the reference, hit run but I get a compile error "end if without block if" which i do not understand. Can someone please assist me in correcting my errors so I can complete this project.
Private Sub Worksheet_Change(ByVal Target As Range)
If "f3" = "yes" Then
Sheets("AcidCalculator").Visible = True
Else
Sheets("AcidCalculator").Visible = False
End If
End IfEnd Sub