current dat on active sheet

[Anonymous]

hi,

i have feild with date, what i need to write in the trigers that every time that i open that sheet

i will see the current day.

i need to do it on the "sheet properteis"?

thnaks'

yarin.

[sushil353]

Hi,

goto Settings>Document Property>Triggers>Document Event Triggers>On Open>Add Action> Action Type(Selection)> Action(Select in field)

Select your date field in field box and in search string =Max(Date_field).

HTH

Sushil

[Anonymous]

hi,

i did what you wrote & it doesn't change the date when i go into that sheet.

you have any idea ?

thanks'

yarin.

[sushil353]

can u share the sample qvw file

[sushil353]

do u want to trigger the date selection whenever u activate the sheet?

if yes then

goto Settings>sheet property> On activate sheet>add action

add action as i told u in the previous post

[khadeer]

Document Properties--->Triggers---->On Open Selections

For Sheet do the same in goto Settings>sheet properties> On activate sheet>add action

Check attached file. Its working for me.

[khadeer · Accepted solution]

Check this updated file

[#8]

You can achive this by using macro onActivateSheet Trigger.

Following is the code to achive your requirement, Hope this will help you,

set sheet=ActiveDocument.ActiveSheet

set sp=sheet.GetProperties

sp.Name= WeekDayName(WeekDay(date))

sheet.SetProperties sp