Don't you just want

activesheet.calculate

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kuba" wrote in message
...
Hello everyone,
I am trying to write a macro that would calculate one of the sheets only
on pressing a certain button, while all the rest of the workbook would be
always calculated automatically.
Is there any way to do so? I start loosing hope to be honest....

All the best

Kuba