Vba: How to calculate all visible worksheets?

[omairhe]

Hello,

What command in vba is required to Calculate all sheets except the hidden ones.
Or
Calculate all sheets other than "Listing" and "HSheet" as these are the only ones which are always hidden in my workbook.

Thanks and will appreciate a lot.

 

[BenGee]

Hi - Not tested but something like this perhaps?

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "Listing" And ws.Name <> "HSheet" Then
ActiveSheet.Calculate
End If
Next