Hi – I am looking for some help
I would like to base weather a macro runs or not based on the day fo
the week.
I have a button for each day of the week that an operator would push t
complete some tasks. I want to avoid the potential of the operato
pushing the wrong button – (I.e. the wrong day).
I was thinking of using =today() and =weekday() functions in workshee
somewhere to test against. So that when the macro starts, I could tes
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 th
operator to choose the right button
Any help !??!?!?!

--
richie
-----------------------------------------------------------------------
richiek's Profile: http://www.excelforum.com/member.php...fo&userid=2769
View this thread: http://www.excelforum.com/showthread.php?threadid=47213