How to reset the edited values of input field

[#1]

hello everyone!!

can any one guide through this.

I have an input field in pivot table which i can edit to my choice.. but after editing it i want to reset the values to its original value .

I have learnt from the posts that it is possible to reset it through reload option by setting some macro in the API but not very clear about the macro code for this.

any solution to this???

[#2]

thanks anywayz .......the problem is solved .. 🙂

[khadeer]

Macro:

----------

Sub reset

activedocument.fields("Ur_FieldName").

ResetInputFieldValues 0

End sub