Hide hidden and equal sheets

If you compare workbooks with large number of worksheets, or VBA modules, you may want to hide equal sheets or modules to focus on the changes only. This is not needed for all tasks, but in some cases this is very useful.

xlCompare has command called Hide Equal Modules It is located on the View tab on the ribbon:

When this option is turned ON, xlCompare hides all worksheets and VBA modules which doesn't have changes, or which are not marked as added\deleted.

By default it is turned OFF.

See Also:

Highlight changes on the scrollbars

Display Number of differences on the Ribbon and on the Sheet Tab