|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 26th, 2008, 08:47 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Multiple sheet updates
What is the correct function to use in my macro if I have many sheets in my
workbook and I need to update them monthly. after I update them, I have the updated date in the footer. I know you can select all the sheets by holding the shift key, but everything I have tried for the date changes everytime I open the workbook. I want the date to change only when I run my macro. 
|
|
#2
September 26th, 2008, 08:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Multiple sheet updates
=If day(now())=1 Then
perform task Or, you can just assign the macro to a button and have it run on click. "Liz" wrote: What is the correct function to use in my macro if I have many sheets in my workbook and I need to update them monthly. after I update them, I have the updated date in the footer. I know you can select all the sheets by holding the shift key, but everything I have tried for the date changes everytime I open the workbook. I want the date to change only when I run my macro.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
