Calculate command

[W Wolfe]

I have a worksheet that has a number of protected cells. If I change the
value in an unprotected cell whose contents are used in the protected cells,
the action is not taken until I hit F9. What VB command is equivalent to the
F9 keyboard command?

 

[XP]

That would be: Application.Calculate

HTH

 

[Bob Phillips]

Worksheet.Calculate

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)