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

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

Worksheet.Calculate

--
---
HTH

Bob


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



"W Wolfe" <(E-Mail Removed)> wrote in message
news:C056AF32-CA7D-48A2-A329-(E-Mail Removed)...
>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