Calculate all sheets

[Pat]

When I sort a sheet other sheets in the workbook with links to the sorted
sheet need re-calculated. I use as part of the custom sort code:

Worksheets("Sheet1").Calculate

Is there an easier way to sort all sheets in the workbook, bearing in mind
they have different names (not sheet1, sheet2 etc)

Pat

[Tom Ogilvy]

Application.Calculate

--
Regards,
Tom Ogilvy

"Pat" <[email protected]> wrote in message
news:[email protected]...
> When I sort a sheet other sheets in the workbook with links to the sorted
> sheet need re-calculated. I use as part of the custom sort code:
>
> Worksheets("Sheet1").Calculate
>
> Is there an easier way to sort all sheets in the workbook, bearing in mind
> they have different names (not sheet1, sheet2 etc)
>
> Pat
>
>