runing macro depending on day

[thesnake505]

Hi have written 7 macros that update a number of workbooks, ecah macro is for each differnt day,

What I want is a macro thats on a button on sheet1 that when pressed will look at that date and then run that day's macro, this means the user can't hit the wrong the wrong button and update Thursdays information on Saturday for example! I have tried a couple but they don't work!

Any ideas?

Thanks for any help

[hamjam]

Greetings

The problem definition is a little loose.
However you could do a check like:

Please Login or Register  to view this content.

coupled with a case statement, corresponding to your different daily macros to run. Then the macros would run when pressing 1 button instead of pressing other command control buttons.

Regards

[thesnake505]

i should explain im really new at vba and strugling a bit, i have search case statments on the internet but im unsure how to tie it in, would this work
say in cell A1 i have

Please Login or Register  to view this content.

Please Login or Register  to view this content.

if i did this all the way to 7 were 1=sunday 2=monday would this work?

i appologise if what i have just wrote is as usefull as a chocolate firegarud but like i say i am new at this!

[thesnake505]

iv just been reading some more and wonderd if this was correct

a1 is still

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[rollis13]

Something like this to get you going:

Please Login or Register  to view this content.

[hamjam]

Hello
Some good progress made, now just couple the items together, i.e. :

Please Login or Register  to view this content.

You just need to make sure the names of the 7 macros as the same as in your case statement. To test, you need to create {sub sunday() end sub} for each one otherwise VBA will complain

[hamjam]

Hello
Some good progress made, now just couple the items together, i.e. :

Please Login or Register  to view this content.

You just need to make sure the names of the 7 macros as the same as in your case statement. To test, you need to create {sub sunday() end sub} for each one otherwise VBA will complain.
Also I had to change the function to "NOW" instead of today() as VBA does not seem to recognise "TODAY"

[thesnake505]

Works a treat now, Evan managed to modify it for other use's!