Hide/unhide button based on data validations

Hi All,

I am creating a disclaimer in one of my sheets.

Cell I15 contains 'Are you a resident for tax purposes?' Cell N15 has the data validation list of Yes or No.

Then I have a button below which covers rows18, 19 and 20.

Is there a way I can have this button hidden until Cell N15 = Yes??

I have tried to read other posts for this but was not able to apply that to my sheet.

Thank you in advance for all your help.

Hi Leith,

I have pasted the code and changed N15 to L13. But what it is doing at the moment is that once the button (in my case is "Bevel 6") is hit only then are the cells showing drop down lists.

Otherwise they are not.

Also, with the codes here is what I have:

PHP Code: 

Sub Workbook_Open()

    Msgbox "Please enable macros before proceeding"
   
End Sub

Private Sub Worksheet_Open()
    ActiveWindow.Zoom = 80
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)

  If Target.Cells.Count > 1 Then Exit Sub

  If Target.Address = "$L$13" And Target.Value = "Yes" Then
     ActiveSheet.Buttons("Bevel 6").Visible = True
  Else
     ActiveSheet.Buttons("Bevel 6").Visible = False
  End If
  
End Sub 


The first code is a Msgbox that should appear as soon as the workbook is open. But it doesn't any ideas??

Thank You for replying

Great!! worked well.

Last question the other codes I have above it, for instance the msgbox. How come that wont work? Is my wording correct?

I want the msgbox to pop up as soon as the workbook is open.

And the only field I have unlocked is L13 yet and everything is locked, yet when I open the book in its locked stated it has some other cell selected??

Once I press enter it goes to L13..

ok here it is.

I have only uploaded the relevant sheet, is that ok? or you prefer the whole workbook?

Anyway, when the workbook is opened, the following should happen:

-A Msgbox should pop up saying: Please enable macros etc..
-Auto zoom to 80%

BUT what is happening is Cell C3 is selected for no reason at all! it is totally irrelevant.

Thanks Leith I really really appreciate your help. This is due in about 3 hours and this is all that I am stuck on.

Not a problem at all

I have just saved it in 97-2003 mode. A lot of 'loss of functionality' things came up so I am not sure that you will be able to see what I really want to show.

Here we go..

Hi Leith,

Its cool now, I played around a bit tried to read and understand what each line means.

I didn't have the code in the 'This Workbook' section.

You have been great, thank you very much for your assistance reps added