Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I currently have two sets of dates ,Fiscal Week & Calendar Week. I Have 1 button selects Fiscal Or Calendar week to be shown.
What I'm trying to do is to get say Page 1; each time it is activated to select the button to show fiscal week if Calendar week is currently selected.
If Fiscal Week is already selected then to do nothing..
Any help would be really appreciated..
Thanks in advance
Dan
Dan,
If I understand this correctly the crux of your issue is to get a button to be pressed when a particular sheet becomes active - ie when the user navigates to Tab2 from Tab1.
Therefore:
On the tab you want to switch to Fiscal Year select Sheet Properties > Triggers and add an Action to the OnActivateSheet event, tha action should launch a macro called 'ButtonPress'.
Enter the Macro editor (Ctrl+m from the front-end) and create the following macro:
Sub ButtonPress
ActiveDocument.GetSheetObject("MyButtonID").Press
End Sub
Now when the sheet is activated the macro will be called by the triggered action and the button will be 'pressed'.
You could easily incorporate all that into one OnActivateSheet action.
Hope that helps,
Matt - Visual Analytics Ltd
Hi Dan,
do each press of your button cycle between fiscal and calendar?
I would then rather use a selection action on sheet activation trigger:
Sheet properties -> Triggers, add an action to the OnActivateSheet, but then action type = "selection" and action = "Select in field" with your calendar type field name and value = "fiscal".
Alternatively, if you want to use a macro you might add a if condition checking the current selection = calendar then activate button.
Regards,
Stefan