How to trigger a command button after a period of time

[Humreid]

Hello everyone please I need any VBA code or Macros that can trigger a command button every Friday, that permits the user only to click on it every Friday to perform a calculation that summed all the "yes" in a yes/no data type. The button should only be active on Fridays.

[Micron]

So if it doesn't get clicked on a Friday (say it's a holiday for instance) then what? Not until next Friday?
I think you are asking for 2 different things as well - click automatically every Friday (if that's what "trigger" means), as well as just make the button enabled so that someone can click it. Even if it has already been done automatically?

[Humreid]

What I actually mean is automatically enabling it on Fridays. If it is not Friday, it won't be clickable, it would be grayed out. But when it is Friday, it will get enabled automatically, and a user can use it to sum the value of what he/she has done so far since Monday.

[isladogs]

Assuming your computer calendar settings have weeks commencing on Sundays, then Sunday is weekday=1 and Friday is weekday =6.
So your code could be

If Weekday(Date)=6 Then Me.YourButtonName.Enabled=True

The button needs to be disabled by default.