Is there a way to hide a button on a sheet unless the date in a cell is the last day of the month?
E Ed Davis May 1, 2007 #1 Is there a way to hide a button on a sheet unless the date in a cell is the last day of the month?
J JE McGimpsey May 1, 2007 #2 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
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
