Clear Macro

[sona_sa]

Hi

Any body can suggest a macro for clear when leave from one sheet to another. If any multibox is selected in one sheet and and when we are leaving from one sheet to anotherone.

Thanks.

[Gysbert_Wassenaar]

Open the properties window of the sheet and go to the Triggers tab. Click on the Add Actions button under OnLeaveSheet. Click on the Add button. Select the Clear All option in the right pane. Click OK to add the action. Click OK twice more to close the dialog windows. Alternatively you could add the action to the OnActivateSheet trigger of the sheet you move to when changing sheets.