| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro by day --- but only once per day
The following code executes a macro based on the day of the week. It
works well. Now I need some help modifying it so that only runs ONLY the first time it is opened each day. Many users can access this shared workbook and the macros put in some default informaion that some users may want to change. Right now that info is changed back to the default info everytime the workbook is opened each day Private Sub Workbook_Open() If (Weekday(Now) = vbMonday) Then [Monday] If (Weekday(Now) = vbTuesday) Then [Tuesday] If (Weekday(Now) = vbWednesday) Then [Wednesday] If (Weekday(Now) = vbThursday) Then [Thursday] If (Weekday(Now) = vbFriday) Then [Friday] End Sub Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Threaded Mode
