I know that my english can be better. Please rate my work and not my lack in linguistic skills!

If you find any kind of ownership issue, or you think some content is your property. Please be so kind and contact me, i will remove or solve it ASAP.

You like my free Uploads and want to support me, than please donate here:

Hide Button when

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
 BOM_anzeigen.Visible = Range("AD2").Value = 0
End Sub

declaration

When in Cell AD2 stands 0 the button will be visible, if not it vanish.

Worksheet_Change Evertime someone changes a cell this makro will work
BOM_anzeigen  Name of the Buttom