Using Review> Check Performance to improve performance is quite useful to me as I use a template workbook for most of my work which contains a lot of macros and data on various sheets.

After a while it can get quite slow – using Review> Check Performance clears this up nicely – is there a way to make this happen automatically within a macro?

Thanks

I used macro record to try and open Check performance and came out with ' Application.CommandBars("Workbook Performance").Visible = False ' - which doesn't work.