merge and compare workbooks button not functioning

[Tracy]

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??

 

[ryguy7272]

I use code like this to compare values on two sheets:
Sub Compare2Shts()
For Each Cell In Worksheets("CompareSheet#1").UsedRange
If Cell.Value <> Worksheets("CompareSheet#2").Range(Cell.Address) Then
Cell.Interior.ColorIndex = 3
End If
Next

For Each Cell In Worksheets("CompareSheet#2").UsedRange
If Cell.Value <> Worksheets("CompareSheet#1").Range(Cell.Address) Then
Cell.Interior.ColorIndex = 3
End If
Next
End Sub

Regards,
Ryan--

 

[Tracy]

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!

 

[Gord Dibben]

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

Cannot be used as you desire.


Gord Dibben MS Excel MVP