command button to do F9 function
Bob,
Thank you for ur reply ?
where shall i put this code ? i m new to VBA ...
does it calculate all the worksheet formula
regards
Jay
Bob Phillips wrote:
Add this to the button code
Activesheet.Calculate
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Jay" wrote in message
ups.com...
Hi,
i want a F9 function to be done by command button when i click on it
i have 10 worksheet all of them have formulas , when i enter data on
first sheet i will click on Command button and it should calculate all
the formulas on all sheet i.e F9 function
can it be done using Macro ? please send methe code for the same.
thank you in advance
regards
Jay
|