Calculate command
 

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?
--
Thanks,

WW

Calculate command
 

That would be: Application.Calculate

HTH

"W Wolfe" wrote:

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?
--
Thanks,

WW

Calculate command
 

Worksheet.Calculate

--
---
HTH

Bob


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



"W Wolfe" wrote in message
...
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?
--
Thanks,

WW