merge and compare workbooks button not functioning
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?? |
merge and compare workbooks button not functioning
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?? |
merge and compare workbooks button not functioning
"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 workbooks button not functioning
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! |
All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com