richiek,

You should write your _single_ macro code to run based on the weekday, not have separate code for
each weekday.

Post your code, and somebody will help....

HTH,
Bernie
MS Excel MVP


"richiek" <[email protected]> wrote in message
news:[email protected]...
>
> Hi - I am looking for some help
> I would like to base weather a macro runs or not based on the day for
> the week.
> I have a button for each day of the week that an operator would push to
> complete some tasks. I want to avoid the potential of the operator
> pushing the wrong button - (I.e. the wrong day).
> I was thinking of using =today() and =weekday() functions in worksheet
> somewhere to test against. So that when the macro starts, I could test
> the =weekday() against a hard coded value on the macro.
> For example:
> If Windows("spreadsheet.xls").Activate
> Range("A!").Select = 4 - (where 4 is equal to =weekday() )
> Then - run the macro ..
> Else - do nothing - or maybe an error message box - telling the
> operator to choose the right button
> Any help !??!?!?!?
>
>
> --
> richiek
> ------------------------------------------------------------------------
> richiek's Profile: http://www.excelforum.com/member.php...o&userid=27697
> View this thread: http://www.excelforum.com/showthread...hreadid=472131
>