Private Sub CommandButton1_Click()
Application.Calculate
End Sub


Cgreate a command button ( Update link and this is the VBA code) first
part of your question, still working on it


T


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=488134