One way (assuming it's a button from your forms toolbar):

Put this in your ThisWorkbook code module:

Private Sub Workbook_Open()
Worksheets("Sheet1").Buttons("Button 1").Visible = _
Day(Date + 1) = 1
End Sub

If you're unfamiliar with macros, see

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In article ,
"Ed Davis" wrote:

Is there a way to hide a button on a sheet unless the date in a cell is the
last day of the month?