Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, can someone tell me how i can automatically clear any date selections when the user maximises a specific chart?
My date fields are :
Cal_Year
Cal_Week
Cal_Period
StoreDate
And the chart i want to maximise is
CH04
I am assuming i would use a trigger, but unsure on which one to use...
Thanks
When you are in the sheet having the chart object CH04,
Go to Settings -> Sheet Properties
Then go to Triggers tab
You can set triggers for 'OnActivate' and/or 'OnDeactivate' events of any sheet object.
Hope this helps.
Hi:
1st -----You can clear manually.
2nd -----You can use a button. Add the action Maximize the object and the action Clear All to the button.
“Document Properties” contains triggers about sheets, general, etc.
“Sheet Properties” contains triggers about objects. Properties about objects are when activating, and deactivating the object.
I didn´t see any trigger when maximizing or restoring.
3rd ------But, you may want to use a macro. I´m sure is possible.
Sub whatever
set c=ActiveDocument.GetSheetObject("CH01")
if c.IsMaximized then
ActiveDocument.ClearAll
else
end if
end sub
3 solutions in one
Have a nice weekend.
Hi, thanks. I only want to clear my date fields, but when i select
ONACTIVATE>> CLEAR OTHER FIELDS>> and add StoreDate into the field box, it doesn't work.
CLEAR ALL works, but i don't want to clear ALL of the selections...
Hi:
Find APIGuide.qvw in your documentation.
ActiveDocument.Fields("Class").Clear
ActiveDocument.Fields("Class").ClearAllButThis
ActiveDocument.Fields("DateField").Select ""
Ok.