hi richardo,
When you press CTr +M then you will see the macro code. This code is been triggen onSelect Event of The Field Area. ( DOcument Properties-->Trigger--> FieldEvent trigger.
how the code works...
set doc = ActiveDocument // initializing the variable
set mySelections = doc.fields("Area").GetSelectedValues // Get the Values of the selected field
if mySelections.count =1 then // check if there is only one selection
ActiveDocument.Sheets(mySelections.item(0).text).Activate // Activate the sheet.. here name of the sheet and the value of the field should be same.
end if
I hope this helps.
