VBA: calculate hidden worksheet

[Puppies72]

Hi all,

I am trying to get a hidden worksheet to calculate but can't seem to get it to run, the code I am using is

Sheets("Terrain").Calculate

can someone show me the correct method to do this, I've looked on these forums and google but cna't seem to find an example that exactly does this

as always help appreciated!

 

[Domenic]

Your syntax seems to be correct. I've just tried it and it seems to work on a hidden worksheet. And, even if the worksheet is protected, it still seems to work. So check to make sure that name of the worksheet is spelled correctly.

 

[Puppies72]

Many thanks for confirming that - found the problem and as the simplest ones are it was spelling (

So thank you!