When WB will open double click in any cell commandbutton will get enable then click commandbutton it will deactivate then double click on any cell it will not enabled, all goods
But issue is this if you close WB and open again and Double click on any cell command button get enabled which I donot want till condition(here i am stuck to make condition)
Actually, I have generated Roster with some code, Roster is based on month I only want this commandbutton enabled once day in a month and if user hit it Roster will generated than this commandbutton disable till next month date
Below is generating dates where I need date which I set at that day this command button will enable and after hitting once it should disable till next date.
Note: if you are looking for dates condition may I can manage, issue is this when condition will met at that date only disabled button after one click (not leave enabled button for 24 Hours)
Code: Select all
vnn = Evaluate("INDEX(FILTER(SEQUENCE(DAY(EOMONTH(TODAY(),0)),1,TODAY()-DAY(TODAY())+1,1),TEXT(SEQUENCE(DAY(" & _ "EOMONTH(TODAY(),0)),1,TODAY()-DAY(TODAY())+1,1),""ddd"")=""Mon""),1)<TODAY()")