VBA Command button enabled if current date matches with range of dates

[KK1234]

Hi
I am trying to find out if command button is enabled on specific dates mentioned in range.
I have attached a sample book.
I could not figure out how to do it.
I have a macro which enables it if specific cells are filled in.
Any help please
Kind regards
KK1234

Codes

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[KK1234]

sample Book attached Now

[nilem]

Hi KK1234,
try it

Please Login or Register  to view this content.

[KK1234]

Hi nilem,
Thanks for your prompt reply.
The line highlighted in debug prompt.
I cant figure out why.
Can you help please?
Thanks again
Kind regards

Please Login or Register  to view this content.

[nilem]

please try again

Please Login or Register  to view this content.

[KK1234]

Hi nilem,
Thanks again.
However the command button still is active with any date.
Apology

[KK1234]

Hi nilem,
I am trying as follows:
Any help please

Please Login or Register  to view this content.

[nilem]

again,
command button is not available

[KK1234]

Wonderful nilem.
I was making a mistake by linking it with D6
Apology. Took a while for me to understand your code.
Its great work.
Many thanks again.
I have clicked * to express my gratitude.
I am closing this thread as solved.
Kind regards
KK1234