Possibly overkill, but check out Application.CalculateFull and
Application.CalculateFullRebuild in the help or
VB IDE Object Browser.
--
jamescox
------------------------------------------------------------------------
jamescox's Profile:
http://www.thecodecage.com/forumz/member.php?userid=449
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=113591