Merge and Compare can only be used different versions of Shared Workbooks.

Cannot be used as you desire.


Gord Dibben MS Excel MVP

On Wed, 6 Feb 2008 08:21:04 -0800, Tracy
wrote:



"Tracy" wrote:

I am trying to do a comparison between an original workbook with a workbook
created from the original which has had changes made to it. I used the help
file to add this button to the quick access toolbar. However, I can not make
the button work. I have the workbook open as I was told do in the help menu
but the button is "greyed" out (the way options normally appear on drop down
menus when you can't use a feature for whatever reason). Any suggestions??

Thanks ryguy7272. I have never used codes like this before but will give it
a try. I was hoping it be something simple like the merge and compare
worksheets button which seems to be enabled even though I activated it.
Appreciate the help though!