hello
i m using a macro to add today date
i want run this macro when i open workbook but only one time in a date
hello
i m using a macro to add today date
i want run this macro when i open workbook but only one time in a date
Hi,
Have a Cell in your workbook that will be the date that you last opened the workbook.
In your code of On_Open, check this cell to see if it is the same as todays date. If the dates are the same then don't perform the code.
If the date in the cell isn't today then run the code and make the cell = today's date.
I hope that makes sense.
Last edited by MarvinP; 04-26-2014 at 12:52 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
sorry
i didn't get the meaning what u want to say
Look at the attached and find the code of:
Please Login or Register to view this content.
Last edited by MarvinP; 04-26-2014 at 10:02 AM.
When i opening workbook there is debugging error
Hi, haroon2015,
maybe just alter
to readPlease Login or Register to view this content.
as you would need to reference a cell instead of a sheet.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
hello HaHoBe
nice catch
works perfect
thanx a lot +1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks