How enable a button if Thursday

[dcmphi]

I want to enable a button of excel sheet if my system day is Thursday. All other day the button will be disabled. Only every Thursday the button will be enable. How to do this?

[jindon]

Something like

Please Login or Register  to view this content.

[dcmphi]

Something like

Please Login or Register  to view this content.

Dear jindon bro your code works fine. Is there any way the button enable on every Thursday and after click the it will be disable for next Thursday?

[bakerman2]

This in thisworkbook.

Please Login or Register  to view this content.

and this at the end of your code attached to the commandbutton.

Please Login or Register  to view this content.

[dcmphi]

bakerman2,

Not works bro. I want my command button will be enable for one click for Thursday only. After one click my button will be disable for next Thursday for one click.

[bakerman2]

Does works bro. Test example file.

[jindon]

dcmphi,

1) Prepare 1 very hidden sheet named like "HiddenSheet".
2) Workbook_Open event code

Please Login or Register  to view this content.

3) Click event code

Please Login or Register  to view this content.

So that the CommandButton will be disabled after the click even you reopen on Thursday again.

[dcmphi]

Does works bro. Test example file.

Deart bakerman2 thanks for your replay.
But I mean every Thursday the button will be enable for one click even if you reopen the workbook again on Thursday the button will not be enable until next Thursday.

[bakerman2]

Yes, the penny dropped.

Check Jindon's code in Post#7.