Hide Buttons based on Result

[rhombus4]

I have 6 buttons which have an individual macro. Based on the result in Cell A1 I want it to only show the button/macro and hide the other 5 but not sure how to do. ~When I right click on a MAcro and click on Assign these are the names that they are currently called and assigned to.

'Book1.xls'!Belgium
'Book1.xls'!Italy
'Book1.xls'!England
'Book1.xls'!France
'Book1.xls'!Spain

 

[rhombus4]

No, it doesn't go in a General module like Module1. Right click the worksheet tab and choose View Code. Put the code in there.

Ok managed to get it to work by just typing the word in Cell A1. Must be it doesnt like the formula in cell A1 is it possible to copy whatever is in cell A1 and put the value somewhere else. and then refer the code to the other cell??? or change the formula.

Also I have a vlookup formula but if an answer isnt in the list how do I get it to say "incorrect" or something similar

 

[Andrew Poulsom]

The Worksheet_Change event won't fire when the result of a formula changes. What is the formula? We need to find a precedent cell that is changed manually.

 

[rhombus4]

The Worksheet_Change event won't fire when the result of a formula changes. What is the formula? We need to find a precedent cell that is changed manually.

=IF(B1="Non Euro","",HLOOKUP(J20,A20:H21,2,0))

 

[Andrew Poulsom]

So what's in A20:H21? Post a snapshot.

 

[rhombus4]

So what's in A20:H21? Post a snapshot.

A20:H20 are just percentages A21:H1 are the countries and J20 has the max formula. So whichever country has the highest percentage will go in cell B1

 

[Andrew Poulsom]

If J20 has a formula what's that? As I said we need to find a precedent cell for A1 that's changed by the user. Otherwise you could use the Worksheet_Calculate event procedure, but that may fire too often.

 

[rhombus4]

if j20 has a formula what's that? As i said we need to find a precedent cell for a1 that's changed by the user. Otherwise you could use the worksheet_calculate event procedure, but that may fire too often.

j20 =max(a20:h20)

 

[rhombus4]

looks like it doesnt like any formula as even if I just try moving to a different cell. ie in D1 and enter =A1 then change the module to If Target.Address <> "$D$1" Then Exit Sub

Also its case sensitive, not only if I enter belgium instead of Belgium it wont work which I understand but also if I dont enter the

Target.Address <> "$D$1" Then Exit Sub with a capital D and use d it doesnt work as well, didnt know cell references were case sensitive

 

[Andrew Poulsom]

So is it A20:H20 that's changed by the user?

 

[rhombus4]

So is it A20:H20 that's changed by the user?

No A20:H20 are updated from another sheet when a macro is run