I've adjusted many settings in my workbook, but I can't remember exactly what I've changed. Is there any way to recover the workbook's default settings?
My workbook has become more slow when I use it, but I can't see any big changes. Is it possible that some cells are 'in use' even though I can't see it and in that way use up memory? I am trying to speed up my workbook by disabling the status bar, disabling events, disabling ErrorCheckingOptions, using manual calculation etc. Do any of you have any other recommendations to speed up the workbook?
I've made a procedure to check if there exists any empty sheets. Can I check/delete anything else?
My workbook has become more slow when I use it, but I can't see any big changes. Is it possible that some cells are 'in use' even though I can't see it and in that way use up memory? I am trying to speed up my workbook by disabling the status bar, disabling events, disabling ErrorCheckingOptions, using manual calculation etc. Do any of you have any other recommendations to speed up the workbook?
I've made a procedure to check if there exists any empty sheets. Can I check/delete anything else?
Code:
For Each sheet In Worksheets
With sheet
If WorksheetFunction.CountA(.Cells) = 0 Then
.Delete
Else
.DisplayPageBreaks = False
End If
End With
Next