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

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

--
RyGuy


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

"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!

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!